Skip to content
This repository has been archived by the owner on Feb 12, 2022. It is now read-only.

Support functional indexes #383

Open
jtaylor-sfdc opened this issue Aug 20, 2013 · 0 comments
Open

Support functional indexes #383

jtaylor-sfdc opened this issue Aug 20, 2013 · 0 comments

Comments

@jtaylor-sfdc
Copy link
Contributor

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant