• This is a powerful link to explain why, and demonstrate that, a single query with multiple functionality has a single plan and that that plan can have dramatically degraded performance.

    http://www.sommarskog.se/dyn-search.html