GilaMonster (10/24/2013)
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.
Agree. Not the best.
covering index will be a better idea but I think covering index will be limited to this query only.