I have inherited a complicated (to me) store procedure. This returns products in categories (by id), or by brand (id), or via a search string, and also checks for any valid attributes (which are dynamic, like material could be metal so an ID for metal would be passed in).
It works in terms of results, but as the data gets larger it gets noticabley slower.
Have attached the plan. Wonder if anyone can help point me in the right direction.
Please let me know if other information would be helpful.
By Hibbo 1 asked Apr 16 at 02:52 PM
There's a lot of stuff in this query that is challenging for performance.
That being said, there definitely are options to improve this.
That's all I have time for right now.
By Hugo Kornelis 271 answered Apr 19 at 08:06 AM
I will go away and go through your suggestions, I have some reading and understanding to do for some of these concepts. Your time in looking over this and feeding back to me is very much appreciated.
By Hibbo 1 answered Apr 19 at 01:54 PM