if you define a column to be sorted, monetdb will use different algorithms to access it, such as binary search and merge joins. In the link you send, as far as I know, the sentence "often freely neglects it" should be interpreted as "neglects it". I am also not aware of the latest status, work is been done on this issues. But until recent, there was no inter-column properties shared in monetdb. so one can not say that column B is subordered on column A (which would lead to a deep clustering schema). What do you want to do? keep in mind that monetdb will create as needed hash indexes and bitmaps(in the default branch, not the stable) without asking you. MonetDB is almost self-tuning when it comes to indexes. On Wed, Aug 28, 2013 at 1:43 PM, Ashish Kumar Singh <ashishkumar.singh@altair.com> wrote:
Hi,
Thanks for your reply.
I am looking for multicolumn clustered index as claimed in http://www.monetdb.org/Documentation/Manuals/SQLreference/Indices
Can I get some more details on "MonetDB uses the sort property as a Cluster" and how to set it?
Regards, Ashish
On 28/08/13 5:10 PM, "Lefteris" <lsidir@gmail.com> wrote:
what do you mean by clustered indexes? multi column clustering? or just one column? in the later, MonetDB uses the sort property as a cluster
On Wed, Aug 28, 2013 at 1:23 PM, Ashish Kumar Singh <ashishkumar.singh@altair.com> wrote:
Any thoughts from anybody?
From: Ashish Singh <ashishkumar.singh@altair.com> Date: Wednesday, 28 August 2013 1:28 AM To: "users-list@monetdb.org" <users-list@monetdb.org> Cc: Ashish Singh <ashishkumar.singh@altair.com> Subject: Clustered Indexes with monetdb
HI All,
Can somebody point me to relevant information on how to do clustered indexes with monetdb?
Regards, Ashish
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list