Use SYS(3054,...,...) to check Optimization.


>For some reason this select statement runs very slow.
>this has been going on for about 6-9 months but have not had time to deal with it.
>
>
>There are 200 records in the Foxpro table
>Takes about a minute to run
>
>SELECT * from training ORDER by Description INTO CURSOR alltrain
>SELECT training
>USE
>SELECT AllTrain
>
>_SCREEN.Height=gnMaxHeight
>_SCREEN.Width=gnMaxWidth
>
>GOTO TOP
>REPORT FORM AllTrain.frx PREVIEW
>USE
>
>
>I have a few of these in this small application and the behavior happens in another small app
>This is the query from it.
>
>CLOSE TABLES
>nYear=0
>SELECT 0
>USE invoices ORDER reportdate
>*REINDEX
>Do FORM Years
>PUSH MENU _MSYSMENU
>
>_SCREEN.Height=gnMaxHeight
>_SCREEN.Width=gnMaxWidth
>
>REPORT FORM income.frx FOR YEAR(invoices.Received)=nYear OR EMPTY(invoices.Received) NOCONSOLE PREVIEW
>
>_SCREEN.Height=gnHeight
>_SCREEN.Width=gnWidth
>
>
>nYear=0
>POP MENU _MSYSMENU
>
>SELECT invoices
>USE