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
- To learn more about how the query optimizer has evolved, see Query optimizer
version history.