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

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Cachito Reyes
Pacheco
Sent: Friday, April 23, 2004 11:13 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: