Explain Plan Optimizer Hint Problem

[townsendEbmud]

In 7.0.2, if I go to an Explain Plan window and enter SQL with an optimizer hint of NO_MERGE(viewalias), the window sets the optimizer goal to ALL_ROWS and ignores my my specific hint. Some hints will get merged in with the window's hint, but this 10g specific hint does not. Also, once the optimizer goal pop-list is chosen, I don't see any way to clear the pop-list to remove the built-in goal without restarting the window. Please fix. Thanks!

 

[Marco Kalter]

I'm not sure I understand. An optimizer mode ALL_ROWS and a NO_MERGE hint are not mutually exclusive.