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

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


Other related posts: