Hi Listers,
I am trying to fix a good plan using outlines. But it doesn't seem to work.
CREATE OR REPLACE OUTLINE OUTLINE_GOOD ON select /*+ RULE */ COUNT(9) from
user_objects;
CREATE OR REPLACE OUTLINE OUTLINE_BAD ON select COUNT(9) from user_objects;
UPDATE OUTLN.OL$HINTS SET OL_NAME = DECODE(OL_NAME, 'OUTLINE_BAD',
'OUTLINE_GOOD', 'OUTLINE_GOOD', 'OUTLINE_BAD')
WHERE OL_NAME IN ('OUTLINE_BAD', 'OUTLINE_GOOD');
COMMIT;
Still query is not using RBO ...or RULE hints . i see costing in the
execution plan.
I am using this note thorougly (Doc ID 2254235.1)
Can you please suggest.
--
Cheers,
Kunwar