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
Received on Wed Apr 28 2004 - 12:13:19 CDT
