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 -> Tablespaces and indexes

Tablespaces and indexes

From: Michiel Brunt <mbrunt_at_inergy.nl>
Date: Thu, 20 Sep 2001 13:32:35 +0200
Message-ID: <9ock03$6lj$1@scavenger.euro.net> 





We created a data warehouse with data spread over multiple tablespaces.
Large tables have their own, others share a tablespace.
In a book about database tuning I read that indexes should be placed in the
same tablespace as the table it is built on.
However, I have heard others say it is better to store indexes in a seperate
index tablespace.



Who can tell me what is best for performance?



Thanks, Michiel
Received on Thu Sep 20 2001 - 06:32:35 CDT












Original text of this message













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