understand how monetdb choose the best query plan
Hello,
J'm new in the use of monetdb, i want to understand how monetdb choose the best query plan. Is the model cost is used for that or what. Please if someone can clarify me. Thank yours time.
On 6 Aug 2019, at 10:45, DEMBELE Simon Pierre simon-pierre.dembele@ensma.fr wrote:
Hello,
J'm new in the use of monetdb, i want to understand how monetdb choose the best query plan.
That’s a too long story to be told here. Please try to narrow down your question and make it more concrete. For what purpose are you using monetdb (e.g. your application env.) and what are you trying to achieve?
Is the model cost is used for that or what. Please if someone can clarify me.
MonetDB uses column properties (e.g. unique, sorted) to make choice between different algorithms (e.g. mergejoin or hash join).
Regards, Jennie
Thank yours time.
-- Simon _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On 06/08/2019 09:32, Ying Zhang wrote:
On 6 Aug 2019, at 10:45, DEMBELE Simon Pierre simon-pierre.dembele@ensma.fr wrote:
Hello,
J'm new in the use of monetdb, i want to understand how monetdb choose the best query plan.
That’s a too long story to be told here. Please try to narrow down your question and make it more concrete. For what purpose are you using monetdb (e.g. your application env.) and what are you trying to achieve?
Is the model cost is used for that or what. Please if someone can clarify me.
MonetDB uses column properties (e.g. unique, sorted) to make choice between different algorithms (e.g. mergejoin or hash join).
Regards, Jennie
Thank yours time.
-- Simon _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Ok thank for your response. Now i need to know if monetdb DB can estimate the instruction per cycle for CPU like in PostgreSql.
participants (2)
-
DEMBELE Simon Pierre -
Ying Zhang