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.
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
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
participants (2)
-
Lefteris -
Shmagi Kavtaradze