Index size

[victor12]

Is there a point in creating indexes with different INITIAL! =NEXT. Or the next_extent >initial_extent .I am new is this field and maybe I am missing something.
I have an index with:
initial_extent=104857600
next_extent = 4096
To me looks like this create performance problems. And better recreate it
What you think?
Thanks

[sanju_dba]

ThumRule for Local Extent Management - Ideal if extents are below two number count ie. below 10.
To achieve this you would take advantage right starting from Initial extent specifications. and for further DiskManagement ur Next,Pctfree will specifications come into picture.
Limitations as of the latest version 9i is u cant go beyond 2G of any each extent size ( precise 2147483646).
To conclude u should consider next extent filling only after ur initial extent is full ** provided u have enough diskspace to accomodate such big extent.

Thanx
Sanjay

[marist89]

You didn't specify if you are using LMT's or not, but I would guess not. The idea behind sizing your extents properly is to reduce fragmentation. Check out http://otn.oracle.com/deploy/performance/pdf/defrag.pdf for details.

[sanju_dba]

sorry about that!!! i meant Dictionary Managed Extents...