Re: Using Flattened table COSTLIER than using JOINS with the SETUP tables.

From: Paul Linehan <plinehan__A_at_T__yahoo__D.OT__COM>
Date: Tue, 07 Aug 2007 21:20:03 GMT
Message-ID: <7m5ui.21337$>

[Quoted] wrote:

> The table will not be in a single block. records should be in a
> single block.
> You would need to use
> analyze table .... compute statistics or better
> exec
> dbms_stats.gather_table_stats(user,'<table_name>',estimate_percent=>NU
> LL)

> doing so you will can query
> select avg_row_len,chain_cnt, num_rows,
> from user_tables where table_name = '<table_name>'

Why? Can't you simply get the db_block_size parameter SQL> SHOW PARAMETER BLOCK and then check against avg_row_len?

My point here is, why gather the stats (which could be useful for other reasons) to find out if the record size exceeds the size of a db block?

Paul... Received on Tue Aug 07 2007 - 23:20:03 CEST

Original text of this message