• Skip to primary navigation
  • Skip to main content

ROB SYMONDS

  • Home
  • About

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.

Copyright © 2023 · Log in

  • RSS
  • Twitter
  • LinkedIn