My understanding is that the parm simply reverts you to pre-9 behaviour where index joins were not there, so there should be no major problems.
hth connor --- April Wells <[EMAIL PROTECTED]> wrote: > > We have discovered an... opportunity... and Oracle's > suggestion is to set > _index_join_enabled = false > > Anyone seen any detrimental effects of setting this > parameter to false in > 9.2.0.#? > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > /\ > / \ > / \ > \ / > \/ > >\< > \ > >\< > \ > Few people really enjoy the simple pleasure of > flying a kite > Adam Wells age 11 > > > The information contained in this communication, > including attachments, is strictly confidential and > for the intended use of the addressee only; it may > also contain proprietary, price sensitive, or > legally privileged information. Notice is hereby > given that any disclosure, distribution, > dissemination, use, or copying of the information by > anyone other than the intended recipient is strictly > prohibited and may be illegal. If you have received > this communication in error, please notify the > sender immediately by reply e-mail, delete this > communication, and destroy all copies. > > Corporate Systems, Inc. has taken reasonable > precautions to ensure that any attachment to this > e-mail has been swept for viruses. We specifically > disclaim all liability and will accept no > responsibility for damage sustained as a result of > software viruses and advise you to carry out your > own virus checks before opening any attachment. ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ________________________________________________________________________ Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs http://www.yahoo.co.uk/robbiewilliams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
