Re: Need Help With SQL Statement Please

In article <4m85du$t18_at_newshost.ptes.com>,

   jamumper_at_ptes.com (James A. Mumper) wrote:
>In Loney's DBA book and the Oracle DBA book is a script which allows you to
 use existing
>data in a table to size the table. The script looks something like this:
>[...]
>The alternative to this is to ANALYZE the tables and then use the avg_row_len
 from
>dba_tables. Does anyone know whether these would be the same as the sql
 script would
>generate?

use analyze table estimate statistics, if the tables are >1000 rows. the results are very good. for large tables with very orderly data, your hand-computed results will not improve estimate stats by more than 5%.

ps., it's easy to write a pl/sql package that scans your schema, builds analyze statements, and (using dbms_sql package calls) executes them.

best regards.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.