Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>In my testing so far, I have about 350 records in table1 and 1.5 million records in table2, and it takes an average of 80 seconds. The full size of table1 will be about 32,000 records... so now we're talking hours.
Since Rushmore is almost surely using the indexes from table2, not the ones from table1, the change in the size of table1 probably isn't going to make a lot of difference here.
One other comment. When you do the testing that Larry suggested, use SYS(3054, 11) rather than SYS(3054,1) - that'll tell you what Rushmore's using to optimize both the join and the filters.
Tamar
Précédent
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