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