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

Oracle LazyDBA home page