You can see the optimized logical operator tree by "explain logical <your query>". And partial operator tree in stages are all optimized one.
Thanks, Navis 2014-12-11 22:09 GMT+09:00 Akash Mishra <akash.mishr...@gmail.com>: > > Hi All, > > I am trying to understand the details of how query is optimize in the > system? > > Is there anything other than EXPLAIN system. As per my understanding > Abstract Syntax tree is not optimize. Is the plan in stage is the optimize > physical plan ? > > -- > > With Sincere Regards, > Your's Sincerely, > > Akash Mishra. > > > "Its not our abilities that make us, but our decisions."--Albus Dumbledore >