Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

windows 2003 server enterprise edition.
The table's content isn't changed since yesterday. Statistics were gathered at 5 am but index statistics
are still missing.

I tried importing the table in another instance inside my office (9207 windows 2000 server)
but here it is all ok. After gathering statistics I see the expected values:

SQL> select s.avg_leaf_blocks_per_key, s.blevel, s.leaf_blocks, s.num_rows, s.clustering_factor
  2 from user_indexes s
  3 where s.index_name = 'PK_T_DIPARTIMENTI_BUDGET'   4 ;

AVG_LEAF_BLOCKS_PER_KEY BLEVEL LEAF_BLOCKS NUM_ROWS CLUSTERING_FACTOR

----------------------- ------ ----------- -------- -----------------
                      1      0           1       73 1

Don't know what to think .........

> Which operating system are you using for this 'troubled' instance?
>
> David Fitzjarrell
Received on Fri Dec 07 2007 - 02:46:06 CST