Dear student of Korea Advanced Institute of Science and Technology in Korea,
aiming at being "nob-less", MonetDB does not offer any means of controlling the query plan. All decisions are taken automatically by the system.
You can inspect both the logical (relational) plan and the physical (MAL) plan by prefixing your queries with keywords PLAN and EXPLAIN, respectively.
Best, Stefan
----- Original Message -----
p{margin:0;padding:0;}
Hello, I'm a student of Korea Advanced Institute of Science and Technology in Korea.
I want to compare late materialization with join and invisible join on monetdb.
But when i typed SQL query, i couldn't choose which query plan to use.
There was no choice to me. I think query optimizer choose some join method.
Can I choose join method? or control query plan?
I installed Monetdb on my desk-top and followed tutorials. Everything is done. There is no error.
In this situation, i tried to control query plan.
So I read reference on official homepage.
But I couldn't find the information that how to control query plan.
Can I control query plan?
If I can, I really really want to know how do that.
Where can i find some example?
Please give me your favor.
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list