sandyinfowave (11/8/2013)
but overall operation cost increased(because of lookups)...
try to implement covering index on non clustered indexes to remove lookups.
sandyinfowave (11/8/2013)
How do we generally determine if a index was helpful??
When time, cpu, io, memory cost get reduced.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)