Google Cloud Database Center V1beta Client - Class InefficientQueryInfo (0.3.1)

Reference documentation and code samples for the Google Cloud Database Center V1beta Client class InefficientQueryInfo.

Metadata about inefficient query signal info for a database resource.

Generated from protobuf message google.cloud.databasecenter.v1beta.InefficientQueryInfo

Namespace

Google \ Cloud \ DatabaseCenter \ V1beta

Methods

__construct

Constructor.

Parameters
Name	Description
`data`	`array` Optional. Data for populating the Message object.
`↳ database`	`string` Name of the database where index is required. For example, "db1", which is the name of the database present in the instance.
`↳ table`	`string` Name of the table where index is required
`↳ sql_index_statement`	`string` SQL statement of the index. Based on the ddl type, this will be either CREATE INDEX or DROP INDEX.
`↳ storage_cost_bytes`	`int\|string` Cost of additional disk usage in bytes
`↳ impacted_queries_count`	`int\|string` Count of queries to be impacted if index is applied

getDatabase

Name of the database where index is required. For example, "db1", which is the name of the database present in the instance.

Returns
Type	Description
`string`

setDatabase

Name of the database where index is required. For example, "db1", which is the name of the database present in the instance.

Parameter
Name	Description
`var`	`string`

Returns
Type	Description
`$this`

getTable

Name of the table where index is required

Returns
Type	Description
`string`

setTable

Name of the table where index is required

Parameter
Name	Description
`var`	`string`

Returns
Type	Description
`$this`

getSqlIndexStatement

SQL statement of the index. Based on the ddl type, this will be either CREATE INDEX or DROP INDEX.

Returns
Type	Description
`string`

setSqlIndexStatement