>>When
>>I encountered this one:
>>
>>Sys(3054,1)
>>
>>SELECT
>>
>>Test_category,sort_index,cost_of_analysis,department_cat,department_code;
>>FROM testlib WHERE testlib.test_code=UPPER(tmp_code) INTO CURSOR
>>spec_cur
>>
>>The system reported that optimization was only partial, but when I run
>>this
>>same query in the command window optimization is full.
>
>In your application do you hae SET DELETED ON, and not have an index for
>DELETED() in the TESTLIB table? This is the most common cause of the
>difference.
>
>/Paul

That was it, thanks.