Re: Updating statistics automatically ... SQL Server V7 does it !

philippe wrote in message <353D9854.14A59605_at_arpege.imaginet.fr>...
>I just read that SQL Server automatically update statistics for the
>query optimizer. Does anybody know if it will also be present in Oracle
>future release because it's a real pain..

Why an auto update? I shudder to think of an Oracle instance that automatically update stats on a 200 million row table while I'm busy with a complex data analysis run...

I think it has to do with fundemental administration concepts. Microsoft attempts to gear their products for minimum support. SQL-Server and NT are for example very easy to administer - unlike Unix or Oracle. To make administration easier, a lot of parameters and admin functions are "moved" as defaults into the standard package where you and I can not touch it. It may make administration easier, but I will think twice about buying a car where the hood is welded to the body of the car and being told that the reason for this is that the car manufacturer does not think it necessary for me to open the hood and maintain with the engine.

If you really want to auto update Oracle table and index stats, there are SQL*Plus scripts and cron - and they can work wonders. ;-)

My 2'c worth.

regards,
Billy Received on Wed Apr 22 1998 - 07:16:58 CDT