>Don't that fields index active
The SCAN FOR automatically uses the index, regardless of whether you include SET ORDER TO or not. In fact, you get your best perfomance if you don't set an order. You could always add NOOPTIMIZE to the SCAN but that would slow it to a crawl in a large table.
David.