Re: Question on tblspace tblspace

ethump5724@my-dejanews.com wrote: > I'm currently installing a Online 7.30 system for a client and loading around > 10Gig of data into two databases. At the moment I'm not specifying extent > sizes on the tables because I'm letting Informix handle it with it's "extent > doubling" capabilities > > What I'm finding is that all of my tables when loaded have one extent BUT in > the entire Online instance I have around 15 tblspace tblspace 's all with an > extent size of 50. > > Is there a way of increasing the extent size for tblspace tblspace, I'm not > altogether sure but it must be better to have one tblspace tblspace instead of > many scattered all over my chunk(s) No, there is no way of increasing the extent size for the tblspace tblspace. I'm not sure it makes any difference whether your tblspace tblspace is fragmented. I can't think of any reason why it would really matter one way or the other. A tblspace tblspace is not something that would ever be sequentially scanned. That said, if you have 15 tblspace tblspace fragments of 50 pages each, it seems that you must have about 750 tables in the same dbspace. Couldn't you separate them out into more dbspaces? June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plain)