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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------