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

From: Nelson, Allan <anelson_at_miswaco.com>
Date: Fri, 23 Apr 2004 11:30:10 -0500
Message-ID: <7E0DB3A126BA9146AC30744E2B7E42459741B4@midhouhqxch01.net.smith.com>

It is a myth because the index has to be read first so the rowid for the table can be determined. At that point an I/O for the table can be done. So index reads and their associated tables are, for any given query, going to be sequential in nature.=20

Allan

-----Original Message-----

=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes Pacheco
Sent: Friday, April 23, 2004 11:13 AM
To: oracle-l_at_freelists.org
Subject: Why "Separating Data and Indexes improves performance" is a myth=3F

Hi
Does any one kwnows please,
Why "Separating Data and Indexes improves performance" is a myth=3F

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=3F

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ =46AQ is at http://www.freelists.org/help/fom-serve/cache/1.html

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

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

Received on Fri Apr 23 2004 - 11:34:30 CDT