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.
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 * FROM SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS
An 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, see Query optimizer overview.
- To learn more about how the query optimizer has evolved, see Query optimizer
versions.