Viewing post 1 (of 1 total)
I finally figured out it is the sampling of data for the statistics that caused SQL Server not to use the index. There are 37 values in the FiscYrMo column...
September 28, 2005 at 3:57 pm
#593863