-
Notifications
You must be signed in to change notification settings - Fork 4k
Closed
Labels
A-sql-encodingRelating to the SQL/KV encoding.Relating to the SQL/KV encoding.A-sql-semanticsC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.T-sql-queriesSQL Queries TeamSQL Queries TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.
Description
Computed indexes are indexes on the result of an expression (as opposed to the direct value of a column). For example: CREATE INDEX a ON customer( LOWER(firstname) || ' ' || LOWER(lastname))
Suggested by @petermattis
silas, pashinin, lopezator, dimpavloff, DavidOliver and 12 more
Metadata
Metadata
Assignees
Labels
A-sql-encodingRelating to the SQL/KV encoding.Relating to the SQL/KV encoding.A-sql-semanticsC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.T-sql-queriesSQL Queries TeamSQL Queries TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.
Type
Projects
Status
Done