----- 原始邮件 -----
发件人：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.

>
> ----- 原始邮件 -----
> 发件人：<chenkaijiang@bigknow.com.cn>
> 收件人：users-list<users-list@monetdb.org>,developers-list<developers-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
> https://www.monetdb.org/mailman/listinfo/users-list
>

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