Class: Google::Spanner::V1::ExecuteSqlRequest::QueryOptions

Inherits:
Object
  • Object
show all
Defined in:
lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb

Overview

Query optimizer configuration.

Instance Attribute Summary collapse

Instance Attribute Details

#optimizer_version ⇒ String

Returns 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 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 will fail with a syntax error (INVALID_ARGUMENT) status.

The optimizer_version statement hint has precedence over this setting.

Returns:

  • (String) —

    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 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 will fail with a syntax error (INVALID_ARGUMENT) status.

    The optimizer_version statement hint has precedence over this setting.



223
 
# File 'lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb', line 223

class QueryOptions; end