Performance: EXISTS vs LIKE 2008-09-21 By Rob Symonds The EXISTS and NOT EXISTS operators can often use an index whereas the LIKE and NOT LIKE operators cause a table scan. This makes EXISTS and NOT EXISTS tend to be more efficient.