I have one table anaylyzed using "compute statistics". It has 2774 Blocks,
which spans over 3 extents, chain_cnt=0, block_size 8192, ave_row_len=47. I
decided to move all data into one larger extent. So I dropped the table,
recreate the table with initial extent = 22M (> 2774 x 8/1024) with all
other storage parameters unchanged. After re-analyzing it, the table has
3015 blocks and spans over 2 extents. I could not figure out why the block
number increases with chain_cnt =0. It spans over 2 extents, not 1 extent
as I expected.
Can anybody advise? Thanks in advance.
--
Allen Guan
yguan_at_houston.rr.com
Received on Tue Apr 08 2003 - 22:10:34 CDT
