Publishers of technology books, eBooks, and videos for creative people

Home > Blogs > Ordering values for IN expressions, Five SQL Tips in Five Days, Part 4

Ordering values for IN expressions, Five SQL Tips in Five Days, Part 4

By  Jul 24, 2008

Topics: Productivity

To speed the evaluation of IN expressions, list the most likely values first.

If you're testing U.S. addresses, for example, list the most populous states first:



Check back here each day this week for more SQL tips.

And for more on SQL, be sure to check out my book SQL: Visual QuickStart Guide, 3rd Edition.