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. |
IS_DEFAULT |
BOOL |
Whether the version is the default version. |
What's next
- To learn more about how the query optimizer has evolved, see Query optimizer
version history.