List query optimizer versions
Spanner provides a built-inSPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONStable to keep track of query optimizer versions. You can retrieve this datausing SQL queries.
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. |
IS_DEFAULT | BOOL | Whether the version is the default version. |
List all supported optimizer versions
SELECT*FROMSPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONSAn example result:
| VERSION | RELEASE_DATE | IS_DEFAULT |
|---|---|---|
| 1 | 2019-06-18 | false |
| 2 | 2020-03-01 | false |
| 3 | 2021-08-01 | true |
What's next
- To learn more about the query optimizer, seeQuery optimizer overview.
- To learn more about how the query optimizer has evolved, seeQuery optimizerversions.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.