Yes. 1.it does & 2. you can.

Muthaiah

----- Original Message -----
From: Sathiya <oracledba-ezmlmshield-x50714889.[Email address protected]
Date: Thursday, September 30, 2004 10:21 am
Subject: Indexes and Data on different Disk

> Dear All,
>
> I have a query on the above subject. I am aware that
> the performance of the database and queries will increase
> if we keep the Index and data on different tablespaces.
>
> I have two questions to this forum
>
> 1. My question is that if we keep index and data tablespace
> (different datafiles) in two separate hard disk will the
> performance increase !!!.
>
> 2. My Hardisk has limited diskspace and one of my tablespace
> kept in one datafile is increasing as the number of transactions
> got increased. Now Can i add one more datafile (that will be
> placed in other drive / harddisk) to this tablespace
>
> Thanks in advance
>
> Regards
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page