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.

About the Author

Photo of Markus Winand
Markus Winand tunes developers for high SQL performance. He also published the book SQL Performance Explained and offers in-house training as well as remote coaching at http://winand.at/

?Recent questions at
Ask.Use-The-Index-Luke.com

0
votes
1
answer
92
views

PostgreSQL Bitmap Heap Scan on index is very slow but Index Only Scan is fast

yesterday Markus Winand ♦♦ 881
index postgresql postgres sql
3
votes
2
answers
363
views

pagination with nulls

2 days ago Rocky 46
pagination
0
votes
2
answers
82
views

Is it possible for PKs to change after Export -> Import?

Oct 29 at 09:21 KaiR 6
integrity mysql