Re: Bit of documentation lacking (indexes, performance)

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/IndexDef... Thanks Alex

On 07/08/2020 8:33 AM Daniel Glöckner 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/P...

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