How to tell MonetDB that data are sorted in the table?

Question

Given a table data (as described below) and given the insurance that that values imported into this table are sorted.

CREATE TABLE data (INT value) 
CREATE INDEX index_value ON data (value)

Since MonetDB can neglect the CREATE INDEX statement (see details here). How do I tell MonetDB that data are sorted in order to let him improves lookup operations ?

score 2 · Accepted Answer · answered Mar 20 '15 at 13:56

From https://www.monetdb.org/pipermail/users-list/2015-March/007932.html (edited) :

MonetDB will detect it automagically. Just make sure the data is indeed ordered upon load. You can check it using the call

select "column","sorted" from storage() where "table"='yourtable';

which contains a column indicating whether MonetDB detected the sorted order.

Please don't double-post both here and on the MonetDB mailing list.

How to tell MonetDB that data are sorted in the table?

1 Answers1