Holger Baer wrote:
> Volker Hetzer wrote:
>> Jim Kennedy wrote:
>>
>>> This isn't MS SQL Server; a modicum of intelligence is assumed.
>>> Just
>>> cause it doesn't say in the package don't do it, doesn't mean you
>>> should. You might be able to log in as sys and manually add rows to
>>> system catalogs, but that isn't a smart thing either.
>>> Jim
>>
>> All right, but what then is the dbms_stats.gather_database_stats
>> procedure there for?
>> I suppose it's not just put in to trap newbies?
>>
>
> I seem to remember that dbms_stats.gather_database_stats for older
> versions automatically excluded the system and sys schema.
Ok. Sounds reasonable.
Lots of Greetings!
Volker
--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
Applications"
Received on Wed Jun 11 2003 - 07:05:50 CDT
