RE: RE: Index-Organized Table experiences

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 28 Apr 2004 13:24:05 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AAEB@usahm018.exmi01.exch.eds.com>

The guesses only take place when the IOT access is via a secondary index which first seeks the logical rowid location. If you are accessing the IOT by PK then the 'guess factor' is not an issue.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net Sent: Wednesday, April 28, 2004 1:16 PM
To: oracle-l_at_freelists.org
Subject: Re: RE: Index-Organized Table experiences

We have alot of many to many relationships. IOTs sound like a good option. However, our many to many relationships are in a high transaction database. I remember reading that Oracle has to 'guess' the location of IOTs and that if you perform alot of DML those guesses can be inaccurate.

anyone have experience with this?

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Wed Apr 28 2004 - 12:23:51 CDT