Skip to content

sql: support expression-based index columns #9682

Closed
@knz

Description

@knz

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

Metadata

Metadata

Assignees

Labels

A-sql-encodingRelating to the SQL/KV encoding.A-sql-semanticsC-enhancementSolution 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.T-sql-queriesSQL Queries TeamX-anchored-telemetryThe issue number is anchored by telemetry references.

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions