Viewing 2 posts - 1 through 2 (of 2 total)
You can query the plan cache for estimated plan costs. You can use this to decide on a suitable cost threshold value for your instance.
Grant Fritchey did a good article...
February 20, 2020 at 11:58 am
#3727318
This is a thing of beauty. It's just saved my bacon.
July 2, 2009 at 8:09 am
#1019172