Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Rushmore Optimization - Or so I thought!
Having never checked, I thought the following SQL was Rushmore optimized.
This SQL is highly simplified and the actual SQL included fields not seen here. The results are the same though.
SELECT plot_id ;
FROM crzplots ;
WHERE plot_id in (SELECT linkfield FROM imsfilter) ;
INTO CURSOR cPlots
Given that the table crzplots has a field called plot_id and it is indexed and the same for the table imsfilter with the field linkfield.
As crzpltos grew, the SQL was taking longer and longer. Looking throught the threads in UT, I noticed several threads refere to SYS(3054). I tried it and was told that the optimization level for both tables was none.
Can this SQL be optimized. Please keep in mind that there are other fields in crzplots. I have deleted the extra fields for clarity. Secondly, crzplots is running about 1 million records and imsfilter can be any number between 1 and RECC("crzplots").
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