Re: data/index on different disks

sigdock wrote:

> Hi all,
>
> I'm building a database for Oracle Text, using Oracle 10.1 on a Win2k3
> platform. Estimated initial size 3GB data and an expected growth of
> 500MB a year. Since I'm using a text index I wonder if it's wise to put
> the index and data tablespaces on different disks. I know that was
> common practice in the Oracle7 and Oracle8(i) days but I remember
> reading somewhere that in Oracle9 and up it's better to put index and
> data on the same disk. Better for read-performance anyway. Anybody here
> with the answer???
>
> tia,
> Bert Jan Meinders

Only separate them if it makes sense from the standpoint of backup and recovery. It will give you nothing of value in terms of performance and inhibits the facile usage of transportable tablespaces.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)