Re: Separating data, index objects

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 16 Jul 2005 20:36:22 +0000 (UTC)
Message-ID: <dbbr46$dpd$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"Joel Garry" <joel-garry_at_home.com> wrote in message news:1121115869.254641.18730_at_z14g2000cwz.googlegroups.com... >

> I have no doubt it would happen regardless even with a full scan hint,
> since hints are just suggestions.

Just happened to catch the tail-end on this, so have no idea where the main thread has been going. But this comment caught my eye.

Hints are NOT just suggestions - they are orders that must be obeyed if they are legal. (Though some newer hints are information - but even then the information will be taken as unarguably true).

A hint will only be ignored if it is out of context or hits a bug. The main reason
that people think Oracle is ignoring a
hint is that there is very little information that explains exactly what each hint is
supposed to do.

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005

Received on Sat Jul 16 2005 - 15:36:22 CDT