-
Please,
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
Best regards
japerez
thanks for your tips now im running the command
validate index
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
-
this usually happens when you almost include all columns
in your index