Re: Index Performance

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 - 10:48:33 CDT