Re: How hints affect the CBO?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 1 Jul 2002 14:49:03 +0400
Message-ID: <afpc38$qo7$1@babylon.agtel.net>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1025341279.8484.1.nnrp-14.9e984b29_at_news.demon.co.uk...

> Hints are mandatory if valid AND if there is
> no way of avoiding the hint.

Hmm... Excuse my ignorance, but doesn't this contradict with the quote from 69992.1? It defines a valid hint as both syntactically and semantically correct and states that if it is ignored in this case, then this is a bug. You say there still may be a case when Oracle will avoid this 'locked' access path and this won't be a bug? And why Oracle would look for a way to avoid the hint? Can you please clarify?

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Mon Jul 01 2002 - 05:49:03 CDT