Hi Sze Sze,

trying to get maximum performance...

You might want to skip the rushmore stuff and use the indexes directly. Depending on what you're trying to do, using SET ORDER, SET RELATIONS, SET FILTER, SEEK, DO WHILE, cursors, buffering, filtered indexes etc, might give you much more performance than using SQL SELECT.

Actually this is quite a difficult topic, and to reach optimum performance you'll have to do quite a bit of testing. Depending on your network the first thing to accomplish is to minimize network and disk i/o.

Walter,


>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