At 12:19 AM 3/6/2004, you wrote:
Regards
Jonathan Lewis http://www.jlcomp.demon.co.uk
: : I have not figured out yet if that can lead to differences in plan : compositions or if it is guaranteed that the relative costs of all plan : components remain the same when comparing a plan stemming from having : o_i_c_a=25 (i.e. single reads cost are 1/4 of multi read costs) vs. having : system statistics where mreadtim = 4*sreadtim. :
In theory it might - It would depend on how Oracle handles the the "plus 1" for tablescans in the new calculation.
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------