Re: How can i estimate the size of hte Index??

There is an extensive set of formulae for estimating the size of objects in the appendixes of the Server Administrator's Guide. There are also at least three sets of algorithms published by Oracle at different times on various web sites. You will be surprised that they give different answers and that the real size of your index, once you create it, is different yet, at times. A rule many of us follow is to double the estimate then double it again.

The manual states "Remember that this
procedure provides a reasonable estimate of an index's size, not an exact number of blocks or bytes. Once you have estimated the size of a index, you can use this information when specifying the INITIAL storage parameter (size of the index's initial extent) in your corresponding CREATE INDEX statement."

ashesh48_at_my-dejanews.com wrote:
: Hi All, I have a que. about how can i estimate the size of the INDEX ?? OR
: its components? LIKE how can i find the size of the Header Size, block header
: etc.? And where can i find the values for this parameters for existing / new
: tables?

: And will estimating size of Index help in tuning issues?

: Any input will be greatly appriciated.

: Ashesh

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- Received on Thu Oct 29 1998 - 13:55:41 CST