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

Thank you very much for the information.

Ashesh

In article <3638c83d.0_at_feed1.realtime.net>,   tpall_at_bga.com (Thomas Pall) wrote:
> 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
>
> --
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 30 1998 - 16:02:22 CST