If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Create index query

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-20-09, 01:15
jnpoulton jnpoulton is offline
Registered User
 
Join Date: Apr 2009
Posts: 1
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?

Thanks
Reply With Quote
  #2 (permalink)  
Old 04-21-09, 03:14
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On