Re: Index tablespace

From: Edwin Esser <eesser_at_hetnet.nl>
Date: Tue, 26 Oct 1999 20:15:36 +0200
Message-ID: <eutBty9H$GA.241@net003s>

Putting the indexes in a seperate tablespace can come in very handy when you put that tablespace on a different disk. That way when you do a query, the index will be accessed through disk 1, the table itself on disk 2 => better performance through better response times.

Edwin

"Alex Yevzelman" <yevz0001_at_tc.umn.edu> wrote in message news:3815E9F2.4EF2619B_at_tc.umn.edu...
> I am wondering, what are the advantages and disadvantages of having a
> separate tablespace for indexes.
> We are converting an MS Access aplication that has ~80Mb and growing of
> data into Oracle 8i. Also, we are developing an application, which will
> have ~10Mb of data.
> I created a tablespace for each of these applications.
>
> Should I create a separate tablespace specifically for indexes or should
> I keep indexes together with the other schema object in each of the
> corresponding tablespaces?
> What are the general guidelines for this type of problem?
>
> Thanks.
> Alex.
>
Received on Tue Oct 26 1999 - 13:15:36 CDT