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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[],[],null,["# List query optimizer versions\n\nSpanner provides a built-in `SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS`\ntable to keep track of query optimizer versions. You can retrieve this data\nusing SQL queries.\n\n`SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS` table schema\n-------------------------------------------------------\n\n### List all supported optimizer versions\n\n SELECT * FROM SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS\n\nAn example result:\n\nWhat's next\n-----------\n\n- To learn more about the query optimizer, see [Query optimizer overview](/spanner/docs/query-optimizer/overview).\n- To learn more about how the query optimizer has evolved, see [Query optimizer\n versions](/spanner/docs/query-optimizer/versions)."]]