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 tablespaces

Re: Index tablespaces

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/04
Message-ID: <3343E70D.6DF8@hk.super.net>#1/1

Bruce Bristol wrote:
>
> Does it make sense to break each index into its own tablespace or is
> there no/little benefit? I would think especially being they indexes
> are of different sizes that it would make some difference.

By concept and experience told me, if you don't have many transaction accessing
the two indexes together (obviously when you inserting record or updating indexed
field of both indexes), don't separate it out.

Since two transactions accessing two objects in same tablespace is no problem.
Only one transaction accessing two objects in same tablespace slow down. Or I should say one transaction accessing two objects in two tablespace MAY be faster.

Regards,
Michael Received on Fri Apr 04 1997 - 00:00:00 CST

Original text of this message

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