Turkbear wrote:
> According to , in addition to others, Thomas Kyte( who I consider one of, if not the, best sources for Oracle info), the SYS
> and SYSTEM schemas (especially SYS) should not be analyzed because the recursive Sql Oracle generated over the years was
> highly optimized for the RULE-based optimizer..Having statistics on a SYS-owned table will cause your database to operate
> slower than it should.
> (paraphrased from "Expert one-on-one Oracle" By Thomas Kyte..Published by Wrox)
>
>
IIRC isn't this for <= 8i, though? I thought that in 9i it was sometimes
done (but only on recommendation from Support?), and in 10g it is the
default?
disclaimer, I've never seen any sys/system schemas analyzed.
Received on Thu Oct 14 2004 - 13:19:30 CDT
