Index not used in "not like" query
99544
postgres: index to SELECT strings like '%foo%';
127553
Why is this MySQL SELECT performing so slowly despite indexing?
48927
how to select record whose matching percentage is higher than other using like operator in sql server?
58680
How do I force Postgres to use a particular index?
144413
PostGIS doesn't use spatial index with ST_Intersects
49279
SQL exclude a column using SELECT * [except columnA] FROM tableA?
123965
Why isn't oracle using an index for distinct query ?
17186
How to get only the unique results without having to sort data?
43252
Search for first and lastname without order
20729
What is an index in SQL?
69956
How to express a NOT IN query with ActiveRecord/Rails?
58304
Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
110437
MySQL: What is a reverse version of LIKE?
120742
MySQL variable format for a "NOT IN" list of values
18410
Filtered Index hint rejected by SQL Server
114214
How do I find records that are not joined?
52581
index() match() join() I want to show all duplicate results disregarding their order