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
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