vineetu1
13th November 2008, 06:20
Can we define extents sizes for Indexs in the inf_storage file for Informix database. The way we do for tables i.e.
1) tfgld106:920:T:group:01:30:INITIAL 1024 NEXT 1024 LOCK row CLUSTERED dbspace bdb_tfgld106
2) tfgld106:920:I::01:: dbspace bdb_tfgld106_idx
In the above we have defined extent size of 1024 for the table, but what about the indexes (line 2)
1) tfgld106:920:T:group:01:30:INITIAL 1024 NEXT 1024 LOCK row CLUSTERED dbspace bdb_tfgld106
2) tfgld106:920:I::01:: dbspace bdb_tfgld106_idx
In the above we have defined extent size of 1024 for the table, but what about the indexes (line 2)