PR #101812 - sql: support setting index visibility in CREATE INDEX and CREATE TABLE

[cockroach-teamcity]

Exalate commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/101812 Commit: https://github.com/cockroachdb/cockroach/commit/d2eac1e03aeaf6460070ada635f2f03fc3655bcc Informs: CRDB-16312

---

Release note (sql change): CREATE INDEX ... VISIBILITY ... as well as CREATE TABLE ... (... INDEX (...) VISIBILITY ...) are now supported. This allows a user to set the 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.

Jira Issue: DOC-7507