Re: Index on different tablespace

Dong Nguyen (INFT801) (dnguyeb_at_site.gmu.edu) wrote:
: Hello,
: I have heard that indexes are read faster if stored in different
: table space. Is this true. If so why?
 

: Doug g

This is true if the indexes are stored on a tablespace on a different physical disk. Its a matter of I/O (disk) contention. By splitting the indexes from the table data, you split the work between disk heads, which should decrease seek time. It becomes very important on large databases or on databases used by a lot of people (processes.) Received on Thu Jan 25 1996 - 00:00:00 CET