docs icon indicating copy to clipboard operation
docs copied to clipboard

PR #87301 - sql: support ALTER INDEX ... VISIBILITY ...

Open cockroach-teamcity opened this issue 2 years ago • 0 comments

Related PR: https://github.com/cockroachdb/cockroach/pull/87301 Commit: https://github.com/cockroachdb/cockroach/commit/452a2de1fb99885b74cd590b72c912e76f25f360 Informs: CRDB-16312 CRDB-16312


Release note (sql change): ALTER INDEX ... VISIBILITY ... is now supported. It can change an index visibility to any visibility within [0.0, 1.0]. Visibility 0.0 means the index is not visible to the optimizer, while visibility 1.0 means the index is fully visible. A value in the range (0.0, 1.0) means the index will be visibile to the corresponding fraction of queries.

Co-authored-by: Rebecca Taft [email protected]

cockroach-teamcity avatar Apr 19 '23 05:04 cockroach-teamcity