by Markus Winand.

Obfuscated Conditions

The following sections demonstrate some popular methods for obfuscating conditions. Obfuscated conditions are where clauses that are phrased in a way that prevents proper index usage. This section is a collection of anti-patterns every developer should know about and avoid.


  1. Dates — Pay special attention to DATE types

  2. Numeric Strings — Don't mix types

  3. Combining Columns — use redundant where clauses

  4. Smart Logic — The smartest way to make SQL slow

  5. Math — Databases don't solve equations

Previous pageNext page

About the Author

Photo of Markus Winand

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing—for that he also published the book SQL Performance Explained.

“Use The Index, Luke!” by Markus Winand is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy | CC-BY-NC-ND 3.0 license