Hi Yes, it will. You can check it using the call SELECT * FROM storage(); which contains a column where MonetDB detected the sorted order. regards, Martin On 19/03/15 21:07, Leon-Constantin Fopa wrote:

Hi, Martin !

Does monetdb will detect sorted data regardless of the create index statement ?

Thank for your fast reply !

best regards,

Fopa Léon Constantin

----- Mail original ----- De: "Martin Kersten" À: "Communication channel for MonetDB users" Envoyé: Jeudi 19 Mars 2015 20:46:00 Objet: Re: How to tell MonetDB that data are sorted in the table?

Hi

MonetDB will detect it automagically. Just make sure the data is indeed ordered upon load.

regards, Martin

On 19/03/15 20:24, Leon-Constantin Fopa wrote:

...

Hi 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 : https://www.monetdb.org/Documentation/Manuals/SQLreference/Indices).

How do I tell MonetDB that data are sorted in order to let him improves lookup operations ?

Best regards,

Fopa Léon Constantin

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list