Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning tsql NOT using INDEX when parameter value in use RE: tsql NOT using INDEX when parameter value in use
Daniel Taylor-446457
Mr or Mrs. 500
Points: 501
More actions
February 4, 2014 at 9:32 am
#1685917
Excellent.
I will endavour to modify the NCI and update the ticket if any issues.
It still interests me as to why such similar queries can perform so differently.
Who knew the optimizer would have this quirk... everybody apart form me :hehe: