Dear Sirs, You will find, especially on this list, that you might attempting to extract a rule from an aggregate statistic. Do not do this if you do not *know* how to measure the details. It is much worse than someone suggesting that count(*) or count(1) is faster. Please, figure out what is CTD, too. Instead of wasting time, bandwith, effort in pursuit of the subject on this email, you *must* immediately purchase, obtain, or access a copy of Optimizing Oracle Performance by Millsap and Holt. And, read it. ;-) HTH. Much humor was apparently missed between-the-lines on these replies. Oh well. Regards, Mike Thomas BTW: The 'C' in CTD is not curiousity, but it could be. :-) --- Srinivasan Vasan <Vasan.Srinivasan@xxxxxxxxxxxxx> wrote: > Is this a difference between RBO and CBO? I am on > CBO on 9.2.0.5 and my > timings are similar to Mladen's - i.e., almost the > same for all types of > counts. > > Cheers, > > Vasan. __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- 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 -----------------------------------------------------------------