On 10/02/2020 16:23, Ying Zhang wrote:

Hai Simon,

What kinds of constraints do you have in mind? Just some quick thoughts: primary key, foreign key and unique constraints often affect MonetDB’s choice for query exec. plans. But, otherwise, it’s a very long story. Coincidently, I was just thinking about writing an article about how query plan generation and optimisation works in MonetDB, but that’ll take some time…

Regards, Jennie

...

On 31 Jan 2020, at 08:52, DEMBELE Simon Pierre wrote:

hello,

I want to know if it is possible to change how monetdb choose a plan by adding new contraints.

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

Hello, I want for example to choose plan based on the definition of new models. - how to integrade this model in monetdb - Use this model to do the choice between two plan. -- Simon