Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why moving indices to a seperate file declines the INSERTS?

Why moving indices to a seperate file declines the INSERTS?

From: Adam Tadjkarimi <adamt_at_hsltd.com>
Date: Mon, 28 Sep 1998 11:05:29 -0500
Message-ID: <6uoc1r$3le$1@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 - 11:05:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US