1. don't believe that. You can gain very limited using this. Try to
access less data as you can for better performance.
2. sure

-----Original Message-----
From: Sathiya
[mailto:oracledba-ezmlmshield-x50714889.[Email address protected]
Sent: Thursday, September 30, 2004 12:51 PM
To: LazyDBA Discussion
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