Re: How is disk space allocated to Indexes?

apatankar@s1.com wrote: >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 rows >to 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? Separate extent in the same dbspace. > If a separate extent is allocated >to the index, then what is the size of that extent? Unknown, but it is supposedly proportional to table size. > What would be the size >of the next extent allocated to the index? Unknow again. > 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? You can't control the size of the extents, but you can control the size of the dbspace. >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading Barry Leb National Linen Service 1420 Peachtree Street MS #314 Atlanta, GA 30309 (404) 853-6119 (404) 853-6485 fax e-mail: barryleb@mindspring.com