Cloud Spanner V1 API - Class Google::Cloud::Spanner::V1::QueryAdvisorResult::IndexAdvice (v1.12.0)

Version latest

• 1.12.0 (latest)
• 1.11.1
• 1.10.1
• 1.9.1
• 1.8.0
• 1.7.1
• 1.6.0
• 1.5.0
• 1.4.0
• 1.3.0
• 1.2.0
• 1.1.0
• 1.0.2
• 0.27.0
• 0.26.0
• 0.25.0
• 0.24.0
• 0.23.0
• 0.22.2
• 0.21.0
• 0.20.1
• 0.19.0
• 0.18.0
• 0.17.0
• 0.16.0
• 0.15.1
• 0.14.1
• 0.13.0
• 0.12.0
• 0.11.0
• 0.10.0
• 0.9.0
• 0.8.1
• 0.7.4

Reference documentation and code samples for the Cloud Spanner V1 API class Google::Cloud::Spanner::V1::QueryAdvisorResult::IndexAdvice.

Recommendation to add new indexes to run queries more efficiently.

Inherits

• Object

Extended By

• Google::Protobuf::MessageExts::ClassMethods

Includes

• Google::Protobuf::MessageExts

Methods

#ddl

def ddl() -> ::Array<::String>

Returns

• (::Array<::String>) — Optional. DDL statements to add new indexes that will improve the query.

#ddl=

def ddl=(value) -> ::Array<::String>

Parameter

• value (::Array<::String>) — Optional. DDL statements to add new indexes that will improve the query.

Returns

• (::Array<::String>) — Optional. DDL statements to add new indexes that will improve the query.

#improvement_factor

def improvement_factor() -> ::Float

Returns

• (::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.

#improvement_factor=

def improvement_factor=(value) -> ::Float

Parameter

• value (::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.

Returns

• (::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.