Details
-
Task
-
Status: Closed
-
Resolution: Fixed
-
None
-
None
-
383
Description
Instead of only defining the set of columns from the data table that make up an index, you should be able to use expressions. For example:
CREATE INDEX upper_last_name_idx ON person (UPPER(last_name))
Then in queries that use UPPER(last_name), we can replace them with column references to the index table.