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 -----------------------------------------------------------------