striping is better or seperate disks

[pando]

Hi

I was wondering which metod would yiled better perfomance, striping or seperating index in a disk and data to another disk?

[apfaunts]

As far as I know just striping. Differentmajor tablespaces should go on different disks but I don't think you should go that far as separating tables and index on different disks. :-)

[abhijit]

You should do both for better performance. Put index and table in different tablespaces. Also, do strip @ operating level.

Regards,

abhijit

[vidhya]

abhijit is right, separating the tables from indexes will lead to better performance. I've read that placing them in different OS mount point is advisable.

vidhya

[wjramsey]

Cary Milsap who used to be with Oracle's Advanced Performace Group wrote an excellent whitepaper on this subject along with a paper on OFA. I'll see if I can locate a link to it and post it here.

Joe