Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Myth revisited ...
okay, it may be no better to place your indexes in a seperate database for
performance sakes, but how then if its not worse why not do it just for
naming sakes convention.
"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
news:3FB6E237.FA9608F_at_yahoo.net...
> At the risk of being shot, drawn and quartered:
>
> I know (and agree with) the fundemental discussion that separating
> indexes and tables into separate tablespaces should not be done for
> performance reasons - in pre-Oracle9i environments!
>
> However, with Oracle9i and it's support for multiple block sizes: Is
> there a possible performance benefit to be obtained by placing the
> tables and [some] indexes in separate tablespaces, IF the tablespaces
> have different blocksizes?
>
> (If this has been previously discussed, please just point me to the
> approximate time frame so I can review the archives.)
>
> /Hans
Received on Sat Nov 15 2003 - 21:14:48 CST