INDEX SIZING

[jmodic]

Originally posted by oravijay
Hi,

You can do the following:
....

Neither of the two methods (selecting from data dictionary or using DBMS_SPACE) give you any information about the number of blocks that contain actual data. They only report you the number opf blocks below and above HWM, nothing more. You can verify this very easily, do the following:

DELETE FROM vj_test; -- delete all rows

ANALYZE TABLE vj_test compute STATISTICS;

Now perform your queries from data dictionary and call DBMS_SPACE.UNUSED_SPACE and see what you get! It should report that all blocks are free, but it is not what your methods actually show.

[SANJAY_G]

Agree with you, jmodic. My query WILL return inaccurate results if tere are chained rows in table.

Sanjay