>Denis,
>check rushmore optimization level with:
>

SYS(3054,12,'mysql')
>Select ...
>SYS(3054,0)
>MESSAGEBOX(mysql)

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?