Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Time to read 6000 (block size 2k) blocks
Jay
EXTENDEDATTRIBUTES E returns 1 row. I would guess that customerid will have better selectivity and would guess that as a number column. So, do you have an index on that column ? And Is that column declared as number (probably not, but I will ask anyway) ? If it is a string column how many distinct values does your statistics indicates assuming CBO for that column.
This would be a good time to turn on that damning 10053 event
too.
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
jaysingh1_at_optonline.net
Sent: Friday, August 06, 2004 10:15 AM
To: oracle-l_at_freelists.org
Subject: Re: RE: Time to read 6000 (block size 2k) blocks
Jurijs
Same execution plan. Nothing got changed.
> jaysingh1_at_optonline.net,
> Can you try:
>
> SELECT --+ ORDERED USE_NL(P, E)
> DISTINCT P.PROFILEDUSERID PROFILEDUSERID,
> SEARCH_LAST_NAME,
> SEARCH_FIRST_NAME
> FROM EXTENDEDATTRIBUTES E,
> PROFILEDUSER P
> WHERE P.PROFILEDUSERID = E.PROFILEDUSERID
> AND P.SEARCH_COMPANY_NAME LIKE 'ACME%' ESCAPE '/'
> AND E.CUSTOMERID = 'ABCDEFGH'
> AND HSBC_USER_CATEGORY IN ('VAL1','VAL2')
> AND ROWNUM < 150
> ORDER BY SEARCH_LAST_NAME,SEARCH_FIRST_NAME
>
>
> Jurijs
> +371 9268222 (+2 GMT)
> ============================================
> Thank you for teaching me. http://otn.oracle.com/ocm/jvelikanovs.html
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Attached file included as plaintext by Ecartis -- -- Desc: Signature The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Aug 06 2004 - 10:26:46 CDT
![]() |
![]() |