Viewing 4 posts - 1 through 4 (of 4 total)
Just for more information, i won't force index. Instead of this, I'll use "option(recompile)" what I read that avoid the parameter sniffing and I test that it work 😀
October 14, 2020 at 11:20 am
Ok about index (Y)
About forcing it, as I saw use paramenter dont use index what I need, I gonna see what index use a normal query and...
October 14, 2020 at 10:53 am
Yes, I read about it, and I rereading your post to understand better and I saw how:
October 14, 2020 at 10:10 am
What are you telling is just that in brentozar's script represent incorrect the result and I can asure you both querys return 20354 rows. Both querys have...
October 14, 2020 at 9:39 am
Viewing 4 posts - 1 through 4 (of 4 total)