RE: RE: Time to read 6000 (block size 2k) blocks
- From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 06 Aug 2004 10:29:52 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
jaysingh1@xxxxxxxxxxxxx
Sent: Friday, August 06, 2004 10:15 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RE: Time to read 6000 (block size 2k) blocks
Jurijs
Same execution plan. Nothing got changed.
----- Original Message -----
From: J.Velikanovs@xxxxxxxx
Date: Friday, August 6, 2004 11:02 am
Subject: Re: RE: Time to read 6000 (block size 2k) blocks
> jaysingh1@xxxxxxxxxxxxx,
> 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
>
>
----------------------------------------------------------------
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
-----------------------------------------------------------------
-- 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@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
-----------------------------------------------------------------
Other related posts:
