Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Create index query

    I'm running IDS 11 and want to address an issue with table and index growth. When I create a table I can nominate extent and growth sizes, but when I create an index I cannot. If I have multiple indexes that reside in the same dbspace then when the table grows the indexes begin to get split over multiple fragments. Is there an option to set an extent growth size for indexes?


  2. #2
    Join Date
    Aug 2005
    no, there is no such option...the database server determines the extent size of an index based on the extent size for the corresponding table.

    But you can create indexes in different dbspaces,than your tables-detached indexes.

Posting Permissions

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