Dear Shmagi,
you can load a table with a sort column and monetdb will figure that out (you might want to run analyze too).
Also monetdb will automatically build a hash index or an imprint index if it figures out that it will speed up queries (joins, range selections etc.).
Also if you are using the default branch and not a stable version of monetdb you can try the experimental code for ordered index (un-clustered ordered index) by defining the index as follows:
CREATE ORDERED INDEX index_name ON table_name(column_name);
This is experimental code, so you might find bugs, if so please let us know.
Lefteris
On Fri, May 6, 2016 at 11:39 AM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:
When searching for index clustering, I read that no user defined index clustering exists in Monetdb. Does it mean that I can not cluster table according to index? If not, how can I sort table to speed-up query?
Thanks in advance.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list