Everyone wants faster database queries, and both SQL ... 3. You can’t use an index with this query because it’s a negative search that has to be compared row by row with a table scan.