MAL optimizer result inspection
Hi, is it possible to look at the output of a specific optimizer? I tried using *optimizer.showFlowGraph*, which just hangs, and *optimizer.showPlan*, which does not show some variables. Is there maybe something I missed? Regards, Moritz
Hi Moritz Thanks for your question and precise test script. The part you are trying out is very very old, specifically designed for a tool not yet in existence anymore. The operation should have been mdb.dot("user","f","test-file") which generates a 'dot' file for graphical display of the structure. However, it currently goes into an infinite loop. I have fixed something in the development branch. the showPlan should be rephrased to mdb.list() The output of the optimizers can be inspected with the DEBUG sql option and the mdb commands. https://www.monetdb.org/Documentation/Manuals/SQLreference/Debug regards, Martin On 02/11/16 16:42, Moritz Bruder wrote:
Hi,
is it possible to look at the output of a specific optimizer? I tried using *optimizer.showFlowGraph*, which just hangs, and *optimizer.showPlan*, which does not show some variables. Is there maybe something I missed?
Regards,
Moritz
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Martin Kersten
-
Moritz Bruder