Hi, Martin, great to hear it, thank you very much! Do you have a schedule, when to release this feature? We're looking forward to running MonetDB in the production environment!  ----- 原始邮件 ----- 发件人：Martin Kersten 收件人：Communication channel for MonetDB users 主题：Re: 回复：Range query in MonetDB 日期：2015-11-26 04:02:19 On 25/11/15 17:08, chenkaijiang@bigknow.com.cn wrote:

Sometimes the traditional DB is 10 to 100 times faster with the help of the index.

Yes. It is on the roadmap.

----- 原始邮件 -----

发件人：

收件人：users-list,developers-list,

主题：Range query in MonetDB

日期：2015-11-25 23:11:07

Since MonetDB actually ignore SQL statement CREATE INDEX, the performance sometimes is quite poor comparing to traditional DB. Such as: https://www.monetdb.org/pipermail/users-list/2008-April/001839.html,

http://stackoverflow.com/questions/22430284/monetdb-slow-query-with-index

In reality, queries with ranges (such as date ranges) are very common and thus index is critical. Sometimes, it gives 100 times performance boost, especially when the queries are relatively simple.

We debug into MonetDB source codes and found that CREATE INDEX only creates an entry in the system catalog.

Is MonetDB going to support index in the coming future, or in some roadmap?

_______________________________________________

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