Expression Index
An expression (functional) index stores the precomputed result of an expression, e.g. an index on lower(email), so a query filtering on that exact expression becomes an ordinary index seek. It is the standard cure for a predicate that cannot be made sargable by rewriting.
This Concept is waiting for its first lesson!
An expression (functional) index stores the precomputed result of an expression, e.g. an index on lower(email), so a query filtering on that exact expression becomes an ordinary index seek. It is the standard cure for a predicate that cannot be made sargable by rewriting.
Are you a teacher? Sign in to start contributing.
Sign In