ANALYZE command question.

From: Dana Stockler <stockler_at_ingdata.no>
Date: 1997/03/03
Message-ID: <01bc27aa$d44fe2a0$910c8fc2@pcs_ws10>#1/1

I am periodically running a batch job that dynamically generates and executes a script which executes the ANALYZE command on all of the tables in the database (except user SYS% tables).

The command executed is:

analyze table <tablename> compute statistics ;

Is this enough to allow the cost-based query optimizer to do it's job well enough? Or should I be using one of the 'for' clauses?

I have the feeling that what I'm currently doing is perhaps too simple. Any suggestions would be appreciated.

-
Regards,
Dana Received on Mon Mar 03 1997 - 00:00:00 CST