Hello support team.
I don't understand why a index is most big than the table itself, i have a table with 84,003,248 rows and i obtain the size as follow , used blocks * block size / 1024 then
(1,261,771 * 8192)/1024 = 10,094,168 -> 10GB and the
index have 1,444,252 * 8192 / 1024 = 11,554,016 -> 11.5GB
the index was created with : pct_free = 10
thanks for your tips now im running the command
and then query the index_stats to determine the porcentage of deleted , unfilled leaf rows in the index
[Edited by japerez on 07-27-2001 at 06:21 PM]
when you delete then insert the free space of table segments is reused but not the indexes, have you tried rebuild indexes?
describe the table and indexes
Oracle DBA and Developer
this usually happens when you almost include all columns
in your index
Click Here to Expand Forum to Full Width