Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Learning more about and reading 10053 trace files

RE: Learning more about and reading 10053 trace files

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 5 Sep 2006 10:07:03 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E1E5A@NT15.oneneck.corp>


Hi Charles - I just read your post quickly and I'm not sure about this, but it sounds to me like maybe there is no "First K" rows calculation for the DISTINCT query because anytime you have a DISTINCT, GROUP BY, ORDER BY or other clause that forces all the data to be fetched and sorted prior to being returned to the user, it makes it impossible to do any type of "FIRST ROWS" processing - because you can't just grab the first 1, 10, or 100 rows until you grab them all and process them as requested, so it makes sense that the CBO wouldn't even consider the cost for such an access method.  

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 05 2006 - 12:07:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US