Re: Data size impact on Performances

From: Ron van Zijl $Prive$ <zijlr_at_yahoo.com>
Date: Sun, 10 Mar 2002 15:51:50 +0100
Message-ID: <a6fs2p$qqv$1@news1.xs4all.nl>

Vincent,

Sorry, there is no nice calculation that can be done (to my knowledge).

The time it would take to update is basically dependent on :

number of indexes
Complexity of the indexes (number of fields in index) Type of index (hash, bitmap, b*tree)
and possible conversion inherent in Funtionale indexes.

I you are doing a batch insert into the table you may use the following strategy

Disable indexes
Load data
Enable and Rebuild indexes

In a lot of cases this is faster than waiting for the regular update of the indexes.

Ron

"V. Fraser" <vincent.fraser_at_canadair.ca> wrote in message news:5092032b.0203071420.7cb2f7ac_at_posting.google.com...
> Hi,
>
> I have an application running with Oracle 8.1.7 under AIX that support
> 250, 000 object in a single table. The table has all the proper
> indexes and was tuned by an Oracle admin.
>
> If I plan to insert new objects in this table to reach a total of 600,
> 000 documents, is their a way to evaluate the impact on a single query
> on this table using an attribute defined in the indexe of this table?
> A special formula? A chart to extrapolate?
>
> Thanks in advance,
>
> Vincent
Received on Sun Mar 10 2002 - 08:51:50 CST