Re: sizing indexes, does anyone have an accurate script or algorithm?

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1998/03/26
Message-ID: <351b3307.67082004@news.dvol.com>#1/1

On Thu, 26 Mar 1998 08:35:46 +1200, Nick Borrell <kwatson_at_netlink.co.nz> wrote:

>Does anyone have an index sizing script for Oracle8 (or 7) which they
>are happy with, and willing to share? I really find it hard to believe
>that there isn't an abundance of these scripts. Wouldn't it be logical
>for Oracle to distribute sizing tools with OEM?

Such a tool would be nice wouldn't it. Microsoft provides one for SQL-Server.

The forumala you're looking for, for btree indexes at least, is in the Server Administrator's Guide. If you've got the HTML version of this, it's the last thing there. If you've got the Adobe version, it's in one of the appendixes... "A" I think.

--
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, sky diving isn't for you.

Received on Thu Mar 26 1998 - 00:00:00 CST