[MonetDB-users] Help,how to create hash index on table

Hello,
Current I am using MonetDB server v5.18.3 , and as i see in Wiki , MonetDB support hash index ,I intended to create a hash index on a table. But how to do it , i have referred to sqlmanual downloaded from monetdb.cwi.nl, but it simply wrote following format:
CREATE [UNIQUE] INDEX

fll wrote:
Hello,
Current I am using MonetDB server v5.18.3 , and as i see in Wiki , MonetDB support hash index ,I intended to create a hash index on a table. But how to do it , i have referred to sqlmanual downloaded from monetdb.cwi.nl, but it simply wrote following format:
CREATE [UNIQUE] INDEX
ON ( , ...) ; MonetDB decides itself when it needs a hash index. There is no control by the user. This SQL statement is simply a noop from the system point of view.
regards, Martin
Is that Btree index or hash index or others? Does MonetDB support multiple column hash index? I am looking forward to your reply.
Thanks a lot.
Andrew. Feng
------------------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
fll
-
Martin Kersten