General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
.4 seconds and you want better?...
Anyway, I don't think you should worry about the "optimization level" reported, given the speed you've got.
**IF** you don't have any deleted records in either table then you might try a run with SET DELETED OFF and see if the optimization reported changes.
cheers
>>* JOIN
>>SELECT cr.plot_id ;
>> FROM crzplots cr ;
>> JOIN imsfilter ff ON ff.linkfield = cr.plot_id ;
>> INTO CURSOR cPlots
>>
>>* Correlated subquery
>>SELECT plot_id ;
>> FROM crzplots ;
>> WHERE EXISTS (SELECT * FROM imsfilter ff WHERE ff.linkfield = cr.plot_id) ;
>> INTO CURSOR cPlots
>
>I think I got it.
>
>Both SQL display the same SYS(3054) message:
>Rushmore optimization level for table cr: none
>Rushmore optimization level for table ff: none
>Joining table ff and table cr using index tag Linkfield
>
>But with about 1.2 million records in crzplots and about 69k in imsfilter, the selection time for the "JOIN" solution is down to .4 seconds.
>
>Should I be concerned that the optimization levels are none? Or can it be even better?
Previous
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