How is disk space allocated to Indexes?
Posted in 1998
My questions are as follows: Assume that you create a table and allocate it an initial extent of some size.Then you create an index on that table in the same dbspace. Then you add rowsto the table, so that nodes get created in the index. Is the space allocated to the index part of the initial extent allocated to the table, or would a separate extent be allocated to the index? If a separate extent is allocated to the index, then what is the size of that extent? What would be the size of the next extent allocated to the index? If an index is created in a separate dbspace from a table, how can we control the size of extents that will be allocated to the index? -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading