How to find full hint naming.
Possible Above 10g R2 (maybe)
select * from table(dbms_xplan.display(null, null, 'outline'));
How to use it.
- sample
FULL(@"SEL$1_2" "T1"@"SEL$1_2")
FULL(@"SEL$1_1" "T1"@"SEL$1")
즉 FULL Hint의 Full Naming Convention은 다음과 같다.
FULL(@query_block_name table_alias_name)
FULL(@"SEL$1_1" "T1"@"SEL$1")
INDEX(@"SEL$1_2" "T1"@"SEL$1_2" ("T1"."C1")) */
This post have a trackback.
http://ukja.tistory.com/trackback/163