Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why moving indices to a seperate file declines the INSERTS?
I think you need to move indices to a different DISK not a different FILE.
Adam Tadjkarimi wrote in message <6uoc1r$3le$1_at_newsin-1.starnet.net>...
>I've inherited a small database (~5 gig) with some design and performance
>problems. One the
>first things I noticed the data and indices reside on the same tablespace,
I
>moved the indices to a
>separate file. To very much of my surprise the performance declined
>drastically for INSERT transactions!!!?, shouldn't it have been other way
>round?
>
>Environment: NT4.0, Oracle 8.04
>
>Thanks in advance,
>Adam Tadj
>
>adamt_at_hsltd.com
>
>Opinions expressed or questions asked are mine not of my employer.
>
>
Received on Mon Sep 28 1998 - 12:53:20 CDT