Index Extents [message #55697] |
Mon, 10 February 2003 10:04 |
Regen
Messages: 3 Registered: February 2003
|
Junior Member |
|
|
I have two indexes ALG_CSM2_PRIM and ALG_CSM2_DATE both of these indexes have MAX_EXTENT 99.
ALG_CSM2_PRIM has 41 extents
ALG_CSM2_DATE has 50 extents
How can I can these extents down???
Thank you
|
|
|
Re: Index Extents [message #55698 is a reply to message #55697] |
Mon, 10 February 2003 12:49 |
Sanjay
Messages: 236 Registered: July 2000
|
Senior Member |
|
|
When you create the index, specify the storage param..
create index alg_csm2_prim
on table_name(col1, col2)
tablespace YOUR_TABLESPACE
storage(INITIAL 1M NEXT 1M MAXEXTENTS 1024)
This is where you set the initial and next extent size as welll as the maxextents number (in this case 1M both intial and next).
Good luck.
|
|
|