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 martin.kersten@cwi.nl 收件人：Communication channel for MonetDB users users-list@monetdb.org 主题：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-listusers-list@monetdb.org,developers-listdevelopers-list@monetdb.org,
主题：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
_______________________________________________
users-list mailing list
users-list@monetdb.org