Re: Using Flattened table COSTLIER than using JOINS with the SETUP tables.
Date: Tue, 07 Aug 2007 21:20:03 GMT
[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
> 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