RE: Oracle 9i hints that are obsolete in 11gR2

From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Thu, 27 Mar 2014 12:51:47 +0400
Message-ID: <OFAE4968D6.F7DA50A2-ON44257CA8.002FE931-44257CA8.0030AFBF_at_psbank.ru>



> In addition, i've just remembered that bypass_ujvc is deprecated now and
also was changed formats of FIRST_ROWS and PARALLEL (ie, parameters)

btw, some hints listed in document [29236.1]:

> NOTE: Starting from Oracle version 10.1.0.2 the following hints have
been deprecated and should not be used:
> AND_EQUAL, HASH_AJ, MERGE_AJ, NL_AJ, HASH_SJ, MERGE_SJ, NL_SJ,
ORDERED_PREDICATES, ROWID, STAR. but as far as i remember, AND_EQUAL, ORDERED_PREDICATES and ROWID still work fine. And sometimes i still see AND_EQUAL and ROWID in outline sections.

--
Best regards, 
Sayan Malakshinov
http://orasql.org 
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 27 2014 - 09:51:47 CET

Original text of this message