Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Index tablespaces
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