Re: Index Performance

Yes, about raid devices. They do the work for you so you don't have to worry about setting up separate devices. Where you put the indexes does not really matter. No?

-Allen

Neil Cudd wrote:

> Generally, tablespaces are used as a means to distribute data across devices
> i.e. Tables on one disk and indicies on the other. Given this configuration,
> an insert into a table and the subsequent update of the index can happen
> asynchronously. If the table and index are on the same device then the two
> operations must happen serially, hence poorer performance.
>
> Raid arrays .. boon or bane ? Discuss.
>
> Allen wrote in message <3815C976.3DC4A4DB_at_email.mot.com>...
> >I have read that performance will suffer if the index for a table
> >is stored in the same tablespace as the table. Is this true and
> >can anyone explain why this is?
> >
> >- Allen
> >fab101_at_email.mot.com
> >
Received on Tue Oct 26 1999 - 13:44:17 CDT