Query optimizer versions

Cloud Spanner provides a built-in SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS table to keep track of query optimizer versions. You can retrieve this data using SQL queries.

Usage

List all supported optimizer versions

SELECT * FROM SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS

Table schema

Column name Type Description
VERSION INT64 The optimizer version.
RELEASE_DATE DATE The release date of the optimizer version.

What's next