General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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").
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only