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 -> Re: INDEX and DATA Tablespaces.....

Re: INDEX and DATA Tablespaces.....

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 17 Sep 2003 08:59:39 -0700
Message-ID: <412ebb69.0309170759.21a53a24@posting.google.com> 





If you have write performance issues having two separate tablespaces
is better. Typical case: If you want to rebuild your index having 2
separate table spaces is much better. In addition two tablespaces must
be on separate physical disks!



For read performance number of tablespaces is not important.
Received on Wed Sep 17 2003 - 10:59:39 CDT












Original text of this message













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