Re: Query gives incorrect results

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 11 Jun 2003 13:55:09 +0200
Message-ID: <3EE7189D.5050706@science-computing.de>

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.

However I did not double check this so I can't give you a reference for this and certainly shouldn't post this at all.

Buggerit :-)

Holger Received on Wed Jun 11 2003 - 06:55:09 CDT