Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> USE_NL with or without ORDERED
!! Please do not post Off Topic to this List !!Hi List,
did anybody notice that sometimes CBO ignores USE_NL hint without ORDERED
The following example was taken from oracle docs:
SQL> SQL> SQL> select name, value
NAME
EMP_ID MGR_ID LAST_NAME FIRST_NAME HIREDATE JOB SALARY SQL> desc courses Name -------------------- CRS_ID SHORT_NAME DESCRIPTION DAYS DEV_ID CAT_ID
4 e.first_name 5 , e.last_name 6 , c.short_name
Explained.
SQL> @opt\explain_n
statement id: 37
Query Plan
1 explain plan set statement_id = '38'
2 for
3 select /*+ use_nl(e) */
4 e.first_name 5 , e.last_name 6 , c.short_name
SQL> @opt\explain_n
statement id: 38
Query Plan
Regards,
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
INET: EShevtsov_at_flagship.ru
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Thu Sep 13 2001 - 06:38:55 CDT