I have a query which is running very slow and we have been asked to extract the explain plan in advanced mode and then use the OUTLINE data as a hint to tune query.
I have never used "OUTLINE Data" to tune the query and the details are very confusing to convert into hints. Please find below some details.
/*+
BEGIN_OUTLINE_DATA
FULL(@"SEL$15" "DB_SRVR_PK"@"SEL$15")
FULL(@"SEL$16" "DB_SRVR_TP"@"SEL$16")
USE_HASH_AGGREGATION(@"SEL$20")
FULL(@"SEL$20" "BSPD"@"SEL$20")
USE_HASH(@"SEL$A876118C" "BJOIN"@"SEL$13")
LEADING(@"SEL$A876118C" "AJOIN"@"SEL$14" "BJOIN"@"SEL$13")
FULL(@"SEL$A876118C" "BJOIN"@"SEL$13")
.
.
.
.
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Please help me with some reference document which explain how to read Outline Data and use the same in Hints.
I have found this method to use Outline Hints, but by using this cost has increased,
http://www.bobbydurrettdba.com/2013/08/30/outline-hint-for-query-tuning/