had a question on some stuff. I a run a long select query in tuning labs...i get about 100+ alternatives(having the re-write engine to NOT use optimizer hints)...i get about 100 rewrite....but most of them have a green dot next to it...and when i move the cursor over....it says outline deployablee. click to deploy ..... out of those 100 rewrite 80 of them are outlines...
so my question is…how can i avoid that as we cannot deploy outlines in our env…just like the option of not using hints…is there a option that the rewrite engine do not use outlines ???
wat does the other 2 dots means ?? the vlue and silver one ??? here is the screenshot of it…please help me avoid the outlines…thanks
toad_10.5.0.33_error_log.txt (19.6 KB)