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

On Nov 26, 2007 7:53 AM, Martin Kersten wrote:

MonetDB internally uses (hash-)indices, which are created for the duration of the session. And the holy grale for database designers is to create a self-organizing system, one that learns how to index without user interaction.

Yes, this would be the case in an ideal world :) Nevertheless the system could take some hints from the schema designer into account (via indexes), in case he exactly knows how the schema is queried and what columns can benefit greatly from having an indexed on them. Markus