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

Markus Gritsch wrote:

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, Sure. It does and ignores it ;-) If the workload is stable then the system should be able to detect and exploit it. For the kind of research activities we undertake, have a look at the Database Cracking papers, which ensures building an index behind the scene based on the actual workload. Anyway, we greatly appreciate your response and experiences. It really helps us to improve the product base.

Markus

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users