Dualcore DBA handles an overly broad class of query:
We have a query that SELECTs from the Users table that takes multiple optional parameters and filters the output based on those.
Whilst fairly easy to read and write, queries written in this way often underperform.
This is a very generous understatement. Click through for two ways to improve the performance of such queries, as well as the pros and cons of each.