Re: Oracle Myths- Tablespace placement answered by Oracle

In article <ac2ufu$mcjir$1_at_ID-114862.news.dfncis.de>, you said (and I quote):
>
> The only reliable benchmark is how it runs on your system.

Yupper.

> Even without concurrency in the strictest sense it is still beneficial to
> put the indexes and data on different disks. The above info relates to one
> query. There is nothing to stop multiple queries against the same rows and
> indexes from processing concurrently.
>
> So yes, you can get performance benefit by splitting the data and indexes
> onto different disks."
>

call me a dreamer, but if you put tables and indexes in same tablespace and spread that tablespace over a number of devices you get EXACTLY the same result as above.

;-D

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam