![](https://secure.gravatar.com/avatar/fef2c36212357b81f48efe7e25cfbf5c.jpg?s=120&d=mm&r=g)
On Tue, Mar 25, 2008 at 02:25:52AM +0100, Michael Schmidt wrote:
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?
The following statement should work.
INSERT INTO tname select * from input_table order by X, Y, Z;
Niels
Regards, Michael
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users