Question on Extent Size

Hi All We are running informix 9.21 on Solaris, the page size is 2k . The db was setup by prev DBA, as i am new to Informix (from oracle) I have few queries on extent size. We have around 100 tables , every table has created with default extent size (16k and next 16k). Some of the tables are showing extent size like table1 : 1208787 next ext 120878 table2: 2472 next 247 56723 next 5672 etc, Some small tables shows still 16k and next extent 16 , But when i run the query to find the no of extents for each table still they show les than 8 extetns some of them even 1 or 2 extents. 1. Is above extents size are ok or will it affect any queries? 2. Do they have to be dropped and recreated? 3. The tables with what extent size needs to be recreated? 3. If i need to recreate , what is the first and next extent size i should give? Any suggestions, guidelines highly appreciated. Thanks in Advance Kalpana

KalpanaPai wrote: > Hi All > > We are running informix 9.21 on Solaris, the page size is 2k . The db > was setup by prev DBA, as i am new to Informix (from oracle) I have > few queries on extent size. > > We have around 100 tables , every table has created with default > extent size (16k and next 16k). > > Some of the tables are showing extent size like > > table1 : 1208787 next ext 120878 > table2: 2472 next 247 > 56723 next 5672 etc, > Some small tables shows still 16k and next extent 16 , > > But when i run the query to find the no of extents for each table > still they show les than 8 extetns some of them even 1 or 2 extents. > > 1. Is above extents size are ok or will it affect any queries? > 2. Do they have to be dropped and recreated? > 3. The tables with what extent size needs to be recreated? > 3. If i need to recreate , what is the first and next extent size i > should give? My guess is that the tables have got too many extents, but they're probably in their own dbspace, so they're increasing contiguously when new extents are added. So basically you're OK.