Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index extent sizing
I think you've picked up half the concept from somewhere.
Yes - get uniform sizing by using the defaults for the tablespace (and setting MINIMUM EXTENT for the tablespace in 7.3+).
but also
Yes, size according to the requirements of the index, by creating a number of different tablespaces each dedicated to a different scale of object, typically
small, medium, large, enormous, completely_ridiculous
Note: aim to have between 1 and 40 extents to a segment as a 'reasonable' number; consider moving an index to the next size of tablespace it gets into the high end of this range.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
blah wrote in message <3839A1D2.CCE46841_at_yahoo.com>...
>I've read somewhere that index extent sizing should remain uniform via
>the tablespace with initial and next being either 256K or 512K.
>
>Is this accurate?, as I thought it best to size individual indexes based
>on size estimates just like tables.
>
Received on Mon Nov 22 1999 - 14:13:27 CST