Re: Updating Statistics for the Data Dictionary -- Or
From: <chadb_at_NeoSoft.com>
Date: 9 Jul 1994 23:06:06 GMT
Message-ID: <2vnagu$s8r_at_uuneo.neosoft.com>
Date: 9 Jul 1994 23:06:06 GMT
Message-ID: <2vnagu$s8r_at_uuneo.neosoft.com>
In <12a.3210.905_at_compudata.com>, barry.roomberg_at_compudata.com (Barry Roomberg) writes:
>-> There are two mechanisms (that I am aware of) for updating statistics
>-> for the data dictionary with Oracle 7.0:
>->
>-> 1. Procedures - ANALYZE_SCHEMA, ANALYZE_OPTIONS
>-> 2. SQL script - CATSTAT.SQL
>
>NEITHER! Do NOT enable the cost based analyzer in Oracle 7.0
>Serious bugs, will not find indexes,will turn previous quick
>code into trash!
>
>Oracle support told me to wait for 7.1 before using it.
>If you accidently analyze anything to gathe r the stats,
>drop them NOW!
Is this true?? I haven't heard this before... rather disturbing...
Chad
-- Chad Brockman | VertiComp, Inc | I'm just an OS/2 Junkie!! chadb_at_NeoSoft.com | "Come on kid, it's cheap!!"Received on Sun Jul 10 1994 - 01:06:06 CEST