Sometimes the traditional DB is 10 to 100 times faster with the help of the index.<div><br>----- 原始邮件 -----<br>发件人：&lt;chenkaijiang@bigknow.com.cn&gt;<br>收件人：users-list&lt;users-list@monetdb.org&gt;,developers-list&lt;developers-list@monetdb.org&gt;,<br>主题：Range query in MonetDB<br>日期：2015-11-25 23:11:07<br><br>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<div><br></div><div>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.</div><div><br></div><div>We debug into MonetDB source codes and found that CREATE INDEX only creates an entry in the system catalog. </div><div><br></div><div>Is MonetDB going to support index in the coming future, or in some roadmap? </div><div><br><br><br></div><br><br><br></div>