Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Query , Faster, How ?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement