ramana3327 (4/15/2014)
Hi,Correct me if I am wrong. I think covering Index is nothing but adding columns that are participating in the where clause right? What about the include columns. What is the main difference for covering index and included columns?
Thanks,
Ramana
You have that backwards. Your key columns (the main columns of your index) should reference your WHERE clause predicates and your SELECT columns are the ones you would INCLUDE to cover.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience