Indeces are used for WHERE clause, not group or order by.
>Ok.
>Interesting results for me
>
>Using index tag
for rushmore optimize table..
>using index tag Deleted to rushmore optimize table..
>Rushmore optimization level for table : full
>
>BUT.. there nowhere using index for "group" - but I groupby group.. and order by group!? is it correct?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer