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

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • Date: Thu, 29 Jun 2006 23:54:01 -0600

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



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


Other related posts: