Re: Index performance

Glen Nunes wrote:
>
> We are having performance trouble with a batch process and we've
> narrowed it down to index performance.
>
> We have created a brand new tablespace on a new drive. Our
> testing indicates a 1000 record insert that takes 6 second
> non-indexed, takes 55 seconds or more when indexed in any of a
> variety of ways.
>
> Can anybody give me an idea of what may be causing this?
>
> Paul Jacobs

Paul,

Insert into an indexed table will take more time than an non-indexed table. This is obvious because each insert has to update the index also.

naren Received on Thu Aug 15 1996 - 00:00:00 CEST