![](https://secure.gravatar.com/avatar/4508564313bd2611de589d6096758f0e.jpg?s=120&d=mm&r=g)
Hello,
A quick question. Is the logical plan generated by the keyword "plan" is the plan before it is sent to the SQL optimizer *OR* the output plan of the optimizer?
From the online documentation (
https://www.monetdb.org/Documentation/Manuals/SQLreference/PlanSQL), this sentence "*The relational plan used in the SQL optimizer* can be obtained by prepending the query with the keyword PLAN." is not clear to me.
Thanks,
Hanfeng Chen
![](https://secure.gravatar.com/avatar/f83acdc781d44181594753b29be7b702.jpg?s=120&d=mm&r=g)
Hi,
The output of the "plan" command is the plan AFTER the optimization.
best regards, Panos.
On 7/1/19 7:44 AM, Hanfeng Chen wrote:
Hello,
A quick question. Is the logical plan generated by the keyword "plan" is the plan before it is sent to the SQL optimizer *OR* the output plan of the optimizer?
From the online documentation ( https://www.monetdb.org/Documentation/Manuals/SQLreference/PlanSQL), this sentence "*The relational plan used in the SQL optimizer* can be obtained by prepending the query with the keyword PLAN." is not clear to me.
Thanks,
Hanfeng Chen
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Hanfeng Chen
-
Panagiotis Koutsourakis