Re: [MonetDB-users] Clustered Index and Merge Join

Hi again,

MonetDB does not support user defined clustered indeces. To have the same effect you will have to sort your data on x-y be explicitly stating it on your insert command, like:

INSERT INTO table_name (...) ORDER BY X,Y

unfortunately, I get a parse error when specifying this statement: "!syntax error, unexpected ORDER, expecting SCOLON [...]". I tried to find something like similar in the manual, but did not succees. So how can I force sorting? And is there any way to sort without an INSERT statement? Regards, Michael