>>>hi,
>>>Does it mean if the rushmore optimisation says :full i cannot make it any faster ???
>>
>>How many records your select returns?
>
>some 1050 records max

It shouldn't take so long. It sunds like your network is very slow. To verify that, copy the table to a local HD and run query from there.