Re: Updating Statistics for the Data Dictionary -- Or
Date: Mon, 11 Jul 1994 19:23:50 GMT
Message-ID: <CssJ7t.MJn_at_mach1.wlu.ca>
In article <2vnagu$s8r_at_uuneo.neosoft.com> chadb_at_NeoSoft.com writes:
>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
>
I havent heard anything that drastic but I was informed that once a single
table (in a query) was "analyzed" then cost based optimizing would take
place. It would guess the rest!
>
>
Received on Mon Jul 11 1994 - 21:23:50 CEST