all session have the optimazer goal CHOOSE, but i want set optimizer goal RULE, how can i do it?
alter session set optimizer_goal=rule
See ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem18.htm#2053036[/url] ) for other options.
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
how can change the optimazer goal in other session?