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 😀

Hi @John-Mitchell-245523

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 I'll put...

Hi @John-Mitchell-245523

Yes, I read about it, and I rereading your post to understand better and I saw how:

• Without parameters, the estimated numbers of rows is 1 (but the real...

• This reply was modified 4 years, 11 months ago by ngonzalez.

Hi @John-Mitchell-245523

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 the same...

• This reply was modified 4 years, 11 months ago by ngonzalez.
• This reply was modified 4 years, 11 months ago by ngonzalez.