On 06/08/2019 09:32, Ying Zhang wrote:

...

On 6 Aug 2019, at 10:45, DEMBELE Simon Pierre 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. -- Simon