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_at_comcast.net">
> 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