Cloud Spanner V1 Client - Class IndexAdvice (2.1.0)

Reference documentation and code samples for the Cloud Spanner V1 Client class IndexAdvice.

Recommendation to add new indexes to run queries more efficiently.

Generated from protobuf message google.spanner.v1.QueryAdvisorResult.IndexAdvice

Namespace

Google \ Cloud \ Spanner \ V1 \ QueryAdvisorResult

Methods

__construct

Constructor.

Parameters
Name
Description
data
array

Optional. Data for populating the Message object.

↳ ddl
array

Optional. DDL statements to add new indexes that will improve the query.

↳ improvement_factor
float

Optional. Estimated latency improvement factor. For example if the query currently takes 500 ms to run and the estimated latency with new indexes is 100 ms this field will be 5.

getDdl

Optional. DDL statements to add new indexes that will improve the query.

Returns
Type
Description

setDdl

Optional. DDL statements to add new indexes that will improve the query.

Parameter
Name
Description
var
string[]
Returns
Type
Description
$this

getImprovementFactor

Optional. Estimated latency improvement factor. For example if the query currently takes 500 ms to run and the estimated latency with new indexes is 100 ms this field will be 5.

Returns
Type
Description
float

setImprovementFactor

Optional. Estimated latency improvement factor. For example if the query currently takes 500 ms to run and the estimated latency with new indexes is 100 ms this field will be 5.

Parameter
Name
Description
var
float
Returns
Type
Description
$this
Design a Mobile Site
View Site in Mobile | Classic
Share by: