RE: Ora 9.2/HPUX 11i/Performance
- From: "Vergara, Michael (TEM)" <mvergara@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Feb 2004 12:40:52 -0800
Wolfgang:
I tried to tell the developers that the inlist was too long,
but they dissed me on that notion. Is this documented
anywhere?
Thanks,
Mike
-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx]
Sent: Thursday, February 19, 2004 12:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Ora 9.2/HPUX 11i/Performance
Your bad query has a lot more (20) items in the in list than the good =
query=20
(12). With that many items it does not use the inlist iterator anymore =
but=20
drives the query with a range scan of an index on LGORT or SPTAG.
If you can not use a hint, tuning suggestions would depend on the exact=20
column and index statistics.
----------------------------------------------------------------
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:
