Index size bigger than table itself ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Index size bigger than table itself ?

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Monterrey, N.L. Mexico
    Posts
    2

    Talking

    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]

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when you delete then insert the free space of table segments is reused but not the indexes, have you tried rebuild indexes?

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    describe the table and indexes
    Oracle DBA and Developer

  4. #4
    Join Date
    Jul 2001
    Posts
    45
    this usually happens when you almost include all columns
    in your index

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width