You can also use SYS(3054,11) to see how your queries are optimized.
>Hi Larry,
>
>To speed up your queries, remove ALLTRIM() from the WHERE clauses and create indexes on PRO_SCHT.SPFLAG, p_number and TRANNUMBER if you dont have them yet.
>BTW, SET EXACT has no effect on Sql Select command.
>
>>Hi Folks -
>>We have the following statement in our code which peforms OK on a table size of less than 10,000 records, anything greater we are running into performance issues. Can anyone advise how we could correct it:
>>
>>...
>>select prod_tran
>>set filter to
>>set order to
>>set exact on
>>SELECT * FROM PRO_SCHT INTO CURSOR PROSCHT WHERE ALLTRIM(PRO_SCHT.SPFLAG)="*"
>>SELECT 0000000000.000 AS CNTRANGE ,* FROM proscht a INTO DBF &pscht where EXISTS(SELECT * FROM PROD_TRAN b WHERE (a.p_number=b.p_number AND ALLTRIM(b.TRANNUMBER)=ALLTRIM(m.trannumber)))
>>
>>PSCHTA=ALIAS()
>>....
>>
>>We need to create the &pscht as a dbf as we are continuously updating it.
>>
>>Thanks,
>>
>>Larry
--sb--