Re: Index on different tablespace

dnguyeb_at_site.gmu.edu (Dong Nguyen (INFT801)) wrote:

> Hello,
> I have heard that indexes are read faster if stored in different
>table space. Is this true. If so why?
 

> Doug g

Performance will be increased if your query is using an index and the data and indexes are on different physical drives.

While one drive is reading the index, the other can be reading the data from the table. If both were on the same drive, it would require a lot of head movement on the drive.

If you bus speed is appreciably greater than your drives transfer rate, the I/O will be much faster as well.

By placing data and indexes in separate tablespaces, you can control which drives they are on.

Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers" jared_at_valleynet.com Received on Wed Jan 24 1996 - 00:00:00 CET