Send feedback
Class QueryOptions (3.57.0)
Stay organized with collections
Save and categorize content based on your preferences.
Version latestkeyboard_arrow_down
QueryOptions ( mapping = None , * , ignore_unknown_fields = False , ** kwargs )
Query optimizer configuration.
Attributes
Name
Description
optimizer_version
str
An option to control the selection of optimizer version.
This parameter allows individual queries to pick different
query optimizer versions.
Specifying latest
as a value instructs Cloud Spanner to
use the latest supported query optimizer version. If not
specified, Cloud Spanner uses the optimizer version set at
the database level options. Any other positive integer (from
the list of supported optimizer versions) overrides the
default optimizer version for query execution.
The list of supported optimizer versions can be queried from
SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS.
Executing a SQL statement with an invalid optimizer version
fails with an INVALID_ARGUMENT
error.
See
https://cloud.google.com/spanner/docs/query-optimizer/manage-query-optimizer
for more information on managing the query optimizer.
The optimizer_version
statement hint has precedence over
this setting.
optimizer_statistics_package
str
An option to control the selection of optimizer statistics
package.
This parameter allows individual queries to use a different
query optimizer statistics package.
Specifying latest
as a value instructs Cloud Spanner to
use the latest generated statistics package. If not
specified, Cloud Spanner uses the statistics package set at
the database level options, or the latest package if the
database option is not set.
The statistics package requested by the query has to be
exempt from garbage collection. This can be achieved with
the following DDL statement:
::
ALTER STATISTICS
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 2025-09-04 UTC.
Need to tell us more?
[[["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-09-04 UTC."],[],[],null,["# Class QueryOptions (3.57.0)\n\nVersion latestkeyboard_arrow_down\n\n- [3.57.0 (latest)](/python/docs/reference/spanner/latest/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.56.0](/python/docs/reference/spanner/3.56.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.55.0](/python/docs/reference/spanner/3.55.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.54.0](/python/docs/reference/spanner/3.54.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.53.0](/python/docs/reference/spanner/3.53.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.52.0](/python/docs/reference/spanner/3.52.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.51.0](/python/docs/reference/spanner/3.51.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.50.1](/python/docs/reference/spanner/3.50.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.46.0](/python/docs/reference/spanner/3.46.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.45.0](/python/docs/reference/spanner/3.45.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.44.0](/python/docs/reference/spanner/3.44.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.43.0](/python/docs/reference/spanner/3.43.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.42.0](/python/docs/reference/spanner/3.42.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.41.0](/python/docs/reference/spanner/3.41.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.40.1](/python/docs/reference/spanner/3.40.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.39.0](/python/docs/reference/spanner/3.39.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.38.0](/python/docs/reference/spanner/3.38.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.37.0](/python/docs/reference/spanner/3.37.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.36.0](/python/docs/reference/spanner/3.36.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.35.1](/python/docs/reference/spanner/3.35.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.34.0](/python/docs/reference/spanner/3.34.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.33.0](/python/docs/reference/spanner/3.33.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.32.0](/python/docs/reference/spanner/3.32.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.31.0](/python/docs/reference/spanner/3.31.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.30.0](/python/docs/reference/spanner/3.30.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.29.0](/python/docs/reference/spanner/3.29.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.28.0](/python/docs/reference/spanner/3.28.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.27.1](/python/docs/reference/spanner/3.27.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.26.0](/python/docs/reference/spanner/3.26.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.25.0](/python/docs/reference/spanner/3.25.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.24.0](/python/docs/reference/spanner/3.24.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.23.0](/python/docs/reference/spanner/3.23.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.22.2](/python/docs/reference/spanner/3.22.2/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.21.0](/python/docs/reference/spanner/3.21.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.20.0](/python/docs/reference/spanner/3.20.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.19.0](/python/docs/reference/spanner/3.19.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.18.0](/python/docs/reference/spanner/3.18.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.17.0](/python/docs/reference/spanner/3.17.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.16.0](/python/docs/reference/spanner/3.16.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.15.1](/python/docs/reference/spanner/3.15.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.14.1](/python/docs/reference/spanner/3.14.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.13.0](/python/docs/reference/spanner/3.13.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.12.1](/python/docs/reference/spanner/3.12.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.11.1](/python/docs/reference/spanner/3.11.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.10.0](/python/docs/reference/spanner/3.10.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.9.0](/python/docs/reference/spanner/3.9.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.8.0](/python/docs/reference/spanner/3.8.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.7.0](/python/docs/reference/spanner/3.7.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.6.0](/python/docs/reference/spanner/3.6.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.5.0](/python/docs/reference/spanner/3.5.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.4.0](/python/docs/reference/spanner/3.4.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.3.0](/python/docs/reference/spanner/3.3.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.2.0](/python/docs/reference/spanner/3.2.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.1.0](/python/docs/reference/spanner/3.1.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [3.0.0](/python/docs/reference/spanner/3.0.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [2.1.1](/python/docs/reference/spanner/2.1.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [2.0.0](/python/docs/reference/spanner/2.0.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.19.3](/python/docs/reference/spanner/1.19.3/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.18.0](/python/docs/reference/spanner/1.18.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.17.1](/python/docs/reference/spanner/1.17.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.16.0](/python/docs/reference/spanner/1.16.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.15.1](/python/docs/reference/spanner/1.15.1/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.14.0](/python/docs/reference/spanner/1.14.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.13.0](/python/docs/reference/spanner/1.13.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.12.0](/python/docs/reference/spanner/1.12.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.11.0](/python/docs/reference/spanner/1.11.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions)\n- [1.10.0](/python/docs/reference/spanner/1.10.0/google.cloud.spanner_v1.types.ExecuteSqlRequest.QueryOptions) \n\n QueryOptions(mapping=None, *, ignore_unknown_fields=False, **kwargs)\n\nQuery optimizer configuration."]]