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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 30 Jun 2006 10:31:20 +0100
Message-ID: <7765c8970606300231w1acc1455teb8cca4a19ddf2b8@mail.gmail.com>

That's true, but I can't really believe that anyone would want each and every piece of SQL in the database, including all the dictionary stuff, to use an index always. Could they?

Niall

On 6/30/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 30 2006 - 04:31:20 CDT