Range query in MonetDB

25 Nov
2015
25 Nov
'15
3:11 p.m.
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?
3393
Age (days ago)
3393
Last active (days ago)
0 comments
1 participants
participants (1)
-
chenkaijiang@bigknow.com.cn