Re: Index tablespace

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Wed, 27 Oct 1999 00:03:35 +0100
Message-ID: <7v5cm9$k5h$1@news4.svr.pol.co.uk>

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