Re: Do I need an Index?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Aug 2005 22:55:02 +0200
Message-ID: <3aqkf1p6qv9vu5u19sds5j69jolqfj74rv@4ax.com>

On 10 Aug 2005 11:32:45 -0700, "mike" <hillmw_at_charter.net> wrote:

>ok so i have an index like:
>
>CREATE INDEX ix_index_id ON orgs(id)
>
>I was noticing pct_free is equal to 10.
>
>Should it be some other value, are there other attributes I need to
>modify?

The value of pct_free depends on how many records you expect to be inserted into that table in the future. If the table hardly ever modifies you can lower it. For normal OLTP tables 10 is sufficient.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Aug 10 2005 - 15:55:02 CDT