Index size Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Index size

  1. #1
    Join Date
    Nov 2001
    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:
    next_extent = 4096
    To me looks like this create performance problems. And better recreate it
    What you think?

  2. #2
    Join Date
    Jan 2002
    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.


  3. #3
    Join Date
    Nov 2000
    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 for details.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2002
    sorry about that!!! i meant Dictionary Managed Extents...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width