but overall operation cost increased(because of lookups)...
try to implement covering index on non clustered indexes to remove lookups.
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;-)