performance improvements from putting tables and indexes on seperate disks?
- From: ryan_gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 08 Feb 2008 19:25:11 +0000
Are there any benchmarks testing whether there are performance improvements on
reads and writes when you separate data and indexes on separate disks?
cases:
1. sqlloader direct path load of a large number of records to a table with 4-5
indexes. The indexes can't be dropped during loads since queries take place
during the load.
My understanding is that the write process is serial so separating the data and
indexes onto separate disks will not improve performance much. I don't have the
disks to test this on right now.
2. queries. mainly oltp type queries. any performance improvements for
separating the hard disks that tables and indexes are on?
This is on a SAN, but we can have it configured to give us separate disks and
show them to us as separate mount points.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
