Re: separate data/inidex

Daniel Morgan <damorgan_at_exesolutions.com> wrote in news:3CC4351E.244AADC3_at_exesolutions.com:

> This is repeated in many places but here are the first two links to it
> I found.
> ------------------------------------------------------------------------
> --------- Place Datafiles Appropriately
>
> Tablespace location is determined by the physical location of the
> datafiles that constitute that tablespace. Use the hardware resources
> of your computer appropriately.
>
> For example, if several disk drives are available to store the
> database, it might be helpful to store table data in a tablespace on
> one disk drive, and index data in a tablespace on another disk drive.
> This way, when users query table information, both disk drives can work
> simultaneously, retrieving table and index data at the same time.

I read this as multiple 'users' querying the table at the same time, which means the drives could be used simultaneously.

Query A reading the index, query b reading the table.    Received on Mon Apr 22 2002 - 11:55:16 CDT