Re: full-scan vs index for "small" tables

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 29 Jun 2006 23:54:01 -0600
Message-Id: <6.2.3.4.2.20060629235241.04b002c0@pop.centrexcc.com>

Except that it is impractical/impossible to adorn each and every sql with such a hint.

At 11:37 PM 6/29/2006, Niall Litchfield wrote:
>On 6/30/06, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
>>It's not indeterministic, but is extremely complex and its very
>>hard to predict
>>the output. What I really need is a "use an index if it exists"
>>parameter that
>>Oracle doesn't want to give us.
>
>That sounds rather like the /*+ INDEX table_alias(colum list) */ hint
>that is available with 10.1 and above to me.
>--
>Niall Litchfield
>Oracle DBA
>http://www.orawin.info

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 30 2006 - 00:54:01 CDT