Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index tablespace
Allen <Allen_Brost-FAB101_at_email.mot.com> wrote in message
news:3815F590.22D6E6BA_at_email.mot.com...
> Yes, but what if you have a raid device? There should be no difference in
> performance
> it that case.
>
> Edwin Esser wrote:
>
> > 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.
> >
Doesn't fragmentation also become an issue if you have tables and indexes in the same tablespace? Although index fragmentation is not a performance problem, table fragmentation is.
Just my 2 pence. Received on Tue Oct 26 1999 - 18:03:35 CDT