Re: [MonetDB-users] Why does MonetDB take indexes not into account?

On 28/11/2007, Niels Nes wrote:

The optimizer nicely finds out that you have an foreign key. This foreign key comes with a join index. Unfortunately when having these indices we do the selects on the base columns, ie on the columns of entry and act independend of the join. And only after that we use the index to combine these results. The improved optimizer will first do the select on the primary key 'column', use the join-index, then the select on this reduced column.

Great. Lets hope this change does not degrade preformance in other cases. Do you have any test suit, which runs various queries, measures their performance, and indicate if performance decreased? Markus