Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.nospamReceived on Fri May 17 2002 - 09:11:21 CDT