Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: Growth in index part is more than Growth in data part of table!!!! How come?

    Hi All.
    I am working with db2 v8.2.2 and AIX 5.2

    Recently after monitoring of production database I found out in period of time for some table growthing of index is a lot larger than growthing of data in that table.

    Could you please let me know how is it possible?

    Thank you in advance for your help.

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    If you have an index on each column (or combined indices on all columns) your index storage will always be larger than your data storage, since the index stores the full column data, in addition to the index structure data and data pointers.
    So even with indices on half of the columns I would expect there will be slightly more index storage than data storage.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by Peter.Vanroose
    If you have an index on each column (or combined indices on all columns) your index storage will always be larger than your data storage, since the index stores the full column data, in addition to the index structure data and data pointers.
    So even with indices on half of the columns I would expect there will be slightly more index storage than data storage.
    Thank you so much Peter.

Posting Permissions

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