>>>>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.

Again there is no network
It is a single system and running on win98, Also the same case with Xp