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

[Quoted] sybrandb_at_hccnet.nl 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