Send feedback
List query optimizer versions
Stay organized with collections
Save and categorize content based on your preferences.
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
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-06 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{
"lastModified": "Last updated 2024-09-06 UTC.",
"confidential": False
}