Search results
Results from the WOW.Com Content Network
Consider this SQL statement: SELECT email_address FROM customers WHERE email_address LIKE '%@wikipedia.org';. This query would yield an email address for every customer whose email address ends with "@wikipedia.org", but even if the email_address column has been indexed the database must perform a full index scan.
In SQL Server, this type of index is called a filtered index. [1] Partial indexes have been supported in PostgreSQL since version 7.2, released in February 2002. [2] SQLite supports partial indexes since version 3.8.0. [3] MongoDB supports partial indexes since version 3.2. [4]