Hi Rick,

Moreover to what everyone suggested try SYS(3054,1) before running the query and SUS(3054,0) after running it. This will allow you to see the level of rushmore optimization and will help to find the non rushmore optimized conditions if any. You may also have a look at SYS(3054,11).

>It is nice to know that the select should respect the condition of the set key even though I can tell perhaps you prefered it did not.
>
>Why is it not doing so in my case, even at the command window where i can have better control proves me wrong on this one. e.g I sele maintable, set order to regions, then set key to "NORTH", BROW LAST and is quick as anything. When I the attempt to use a select * on the same table with the key set. I get the whole table in a result window of 120,000 rec's but the seting of the key to NORTH displays 23,000 records. What am I doing wrong?
>
>I have an index on UPPER(REGION).
>I have also used where region = "NORTH" and ... and ... etc...
>But it takes several minutes to query, should this be the case.(P200MMX 64RAM)
>I do not have an index on deleted() and set deleted is off.
>I am selecing into a temp table that has no indexes. I could build one each time the select statement is run. This is a bit slow, creating an index on or reindexing the temp table, don't you think? then theres the last performance hit when I finally brow the temptable.
>
>TIA Again!!!