Daniel
Indexes are rather used for functional needs because of unique design of the product to build performance related indexes automatically.
From my experience adding index manually does not improve performance of most queries.

Here is more about it https://www.monetdb.org/Documentation/SQLreference/TableDefinitions/IndexDefinitions

Thanks
Alex
On 07/08/2020 8:33 AM Daniel Glöckner <gloeckner.daniel@gmail.com> wrote:


Hi,

I'm currently in the process of evaluating MonetDB. Hats off for this great product!
Very impressed by ease-of-use and performance so far.

Looking for information what indexes are used by MonetDB I found a pretty empty page only:
https://www.monetdb.org/Documentation/SQLReference/Indexes

During our performance evaluation I was searching for common recipes to achieve good performance. Following page is unfortunately also under construction.
https://www.monetdb.org/Documentation/SQLReference/PerformanceOptimization/PerformanceTips

Is there any performance handbook available?

I also did not find information regarding (performance) parameters for the DB server.

Kind regards,
Daniel
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list