Re: performance improvements from putting tables and indexes on seperate disks?

Found the second one, it had a slightly misleading title "Oracle 7 Server" on 
Google...

http://www.oracle.com/technology/deploy/availability/pdf/SAME_HP_WP_112002.pdf



<lainaus kuka="ryan_gaffuri@xxxxxxxxxxx">
> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Riku Räsänen
Kantamestarit OY
www.kantamestarit.fi

--
http://www.freelists.org/webpage/oracle-l


Other related posts: