General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
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