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
>

Reply via email to