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