RE: Ora 9.2/HPUX 11i/Performance

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Thu, 19 Feb 2004 12:40:52 -0800
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91BD8@temmse06.tem.guidant.com>

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_at_centrexcc.com] Sent: Thursday, February 19, 2004 12:24 PM To: oracle-l_at_freelists.org
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_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 Thu Feb 19 2004 - 14:40:52 CST