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

  • From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Apr 2004 12:13:12 -0400

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


----------------------------------------------------------------
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
-----------------------------------------------------------------

Other related posts: