Jump to content

Expression index

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Decibel (talk | contribs) at 16:18, 20 January 2007 (Created page with 'An '''expression index''' is a database index that is built on a generic expression, rather than on a...'). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

An expression index is a database index that is built on a generic expression, rather than on a list of columns. This allows indexes to be defined for common

which has some condition applied to it such that it only includes a portion of the rows in the table.