T.Ashish (10/24/2013)
create your index onyearno
periodid
Sure that's the best index? A non-covering index that only supports the where clause.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability