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]