Viewing 2 posts - 1 through 2 (of 2 total)
You may find that my previous link has a lot of overlap with your findings: http://www.sommarskog.se/dyn-search.html
Lots of test cases, a bucket load of data, results, timings, implications, etc....
April 25, 2015 at 1:32 pm
#1793484
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.
April 18, 2015 at 2:10 pm
#1791829