Re: Dbms_stats Analyze Data Dictionay ?

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0305261628.76bff75d_at_posting.google.com...
> Actually since version 7.3 any hint in an SQL statement, except for
> the RULE hint, causes the CBO to be invoked for the statment. In
> version 8.1 some of Oracle's data dictionary (recursive) queries are
> hinted, so the CBO is and has been used on some rdbms dictionary
> queries for a while. I think I first noticed the hints in version 8,
> but it gets hard to remember.
>
> Just adding to the discussion -- Mark D Powell --

*some* !!!

My impression is that it was 8i, but I find it hard to recall last week.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************