Re: Why "Separating Data and Indexes improves performance" is a myth?

Juan Cachito Reyes Pacheco wrote:

> Hi
> Does any one kwnows please,
> Why "Separating Data and Indexes improves performance" is a myth?
>
> If they are both accesed at the same time, it will improve performance or
> not,
> I don't understand exactly what is this myth about?
>
> http://www.niall.litchfield.dial.pipex.com/OracleMyths.zip
>
> Thanks
>
>
> Juan Carlos Reyes Pacheco
> OCP
> Database 9.2 Standard Edition

Not having read the zip file that Niall has provided, here are a few threads that should give you plenty of detail, and various opinions, about that particular "myth"

http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=9u3ub.14700%24aT.6285%40news-server.bigpond.net.au&rnum=2&prev=/groups%3Fq%3Doracle%2Bmyth%2Bseparate%2Bindex%2Bfoote%26btnG%3DSearch%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=aak5t5%24l57%241%40lust.ihug.co.nz&rnum=8&prev=/groups%3Fq%3Doracle%2Bmyth%2Bseparate%2Bindex%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=ue4sg0gm4fdbdc%40corp.supernews.com&rnum=15&prev=/groups%3Fq%3Doracle%2Bmyth%2Bseparate%2Bindex%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DN

-- 
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------