Greetings,

I've been doing some Profiler traces and found that many
of the table scans happen primarily on non-clustered
indexes. For example, table 1 has 736,663 rows and 11
indexes. Index 1 (the clustered index) was used 570 times
while index 4 was used 3,063 times. Does it make sense in
this case to make index 4 the clustered index rather than
index 1?

Thanks for any advice