Hi!

Read articles on Rushmore optimization in help file.

sys(3054) shows optimization level for filters in the WHERE contdition only. Join condition does use optimization, but never reported by sys(3054) function in VFP6.0 (in VFP7.0 it does reports).

If you will post you queries (or at least join conditions and WHERE conditions), probably we will tell you exactly which indexes required to add to speed up queries. Again, read articles in MSDN, probably you will figure this out by self.

>I got over 10 tables,
>And I use more than 10 queries to calculate some data .
>some queries are used to join several tables....
>
>
>I find that each queries spends over 5-8 seconds. (there are average 4500 records in each tables)
>
>I use SYS(3054) . and find that the rush optizmation is 'NONE'.
>
>How can i Speed up it ?
>
>I saw the preivous posting ' some said DELETE() index....'
>And I don't understand What is it !
>
>Can someone explain in more detail ?
>Thanks in advance
>From Agnes