I agree that's a wide index. Sorry, for not making this clear in the original request. My original index was on [Company_No],[Period],[Year_For_Period] and incredibly the performance between that index and the current one listed in my last post yielded about the same performance (within 1 second consistently)...

I did notice you mentioned clustered and I didn't have either as a clustered index. I can try that one while I wait for another response..

Thanks