Performance: EXISTS vs LIKE

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.

Wow. It's Quiet Here...

Be the first to start the conversation!

Leave a Reply:

Gravatar Image