public sealed class QueryOptions : IEquatable<QueryOptions>Immutable class representing query options.
Implements
IEquatable<QueryOptions>Namespace
Google.Cloud.Spanner.DataAssembly
Google.Cloud.Spanner.Data.dll
Properties
Empty
public static QueryOptions Empty { get; }Creates query options without specifying any options.
| Property Value | |
|---|---|
| Type | Description |
QueryOptions | |
OptimizerVersion
public string OptimizerVersion { get; }The query optimizer version configured in the options.
| Property Value | |
|---|---|
| Type | Description |
String | |
Methods
FromProto(ExecuteSqlRequest.Types.QueryOptions)
public static QueryOptions FromProto(ExecuteSqlRequest.Types.QueryOptions proto)Set query options from the given proto.
| Parameter | |
|---|---|
| Name | Description |
proto | Google.Cloud.Spanner.V1.ExecuteSqlRequest.Types.QueryOptionsThe proto to construct QueryOptions from. |
| Returns | |
|---|---|
| Type | Description |
QueryOptions | |
The given proto should not be null. The given proto is cloned.
GetHashCode()
public override int GetHashCode()| Returns | |
|---|---|
| Type | Description |
Int32 | |
ToProto()
public ExecuteSqlRequest.Types.QueryOptions ToProto()Get proto version of the query options.
| Returns | |
|---|---|
| Type | Description |
Google.Cloud.Spanner.V1.ExecuteSqlRequest.Types.QueryOptions | |
WithOptimizerVersion(String)
public QueryOptions WithOptimizerVersion(string optimizerVersion)Clones the options and sets the optimizer version to the given value.
| Parameter | |
|---|---|
| Name | Description |
optimizerVersion | StringOptimizer version to set. |
| Returns | |
|---|---|
| Type | Description |
QueryOptions | A clone of the options with the updated optimizer version. |
The 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.