public sealed class QueryOptions : IMessage<ExecuteSqlRequest.Types.QueryOptions>, IEquatable<ExecuteSqlRequest.Types.QueryOptions>, IDeepCloneable<ExecuteSqlRequest.Types.QueryOptions>, IBufferMessage, IMessage
Query optimizer configuration.
Implements
Google.Protobuf.IMessage<ExecuteSqlRequest.Types.QueryOptions>, IEquatable<ExecuteSqlRequest.Types.QueryOptions>, Google.Protobuf.IDeepCloneable<ExecuteSqlRequest.Types.QueryOptions>, Google.Protobuf.IBufferMessage, Google.Protobuf.IMessageNamespace
Google.Cloud.Spanner.V1Assembly
Google.Cloud.Spanner.V1.dll
Constructors
QueryOptions()
public QueryOptions()
QueryOptions(ExecuteSqlRequest.Types.QueryOptions)
public QueryOptions(ExecuteSqlRequest.Types.QueryOptions other)
Parameter | |
---|---|
Name | Description |
other | ExecuteSqlRequest.Types.QueryOptions |
Properties
OptimizerVersion
public string OptimizerVersion { get; set; }
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.
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.
Property Value | |
---|---|
Type | Description |
String |