Cloud Spanner V1 Client - Class IndexAdvice (2.1.0)

Version latest

• 2.1.0 (latest)
• 2.1.0-RC1
• 2.0.1-RC1
• 1.106.0
• 1.105.1
• 1.104.1
• 1.103.0
• 1.102.0
• 1.101.0
• 1.100.0
• 1.98.0
• 1.97.0
• 1.96.0
• 1.95.0
• 1.94.0
• 1.93.1
• 1.92.1
• 1.91.0
• 1.90.0
• 1.89.0
• 1.88.0
• 1.87.0
• 1.86.0
• 1.85.0
• 1.84.0
• 1.83.0
• 1.82.0
• 1.81.0
• 1.80.0
• 1.79.0
• 1.78.0
• 1.77.0
• 1.76.1
• 1.68.0
• 1.67.0
• 1.66.0
• 1.65.0
• 1.64.0
• 1.63.2
• 1.62.1
• 1.61.0
• 1.60.0
• 1.59.0
• 1.58.4
• 1.57.0
• 1.56.0
• 1.55.0
• 1.54.2

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
Google\Protobuf\Internal\RepeatedField

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