For question (a) there are too many variables about your environment for anyone to benchmark against. As for (b), MonetDB doesn&#39;t pay attention to user specified indexing.<br><br>For the query you ran, did you run it twice in a row? Was the system swapping during the query?<br>
<br><div class="gmail_quote">On Fri, Mar 20, 2009 at 11:58 AM, Yue Sheng <span dir="ltr">&lt;<a href="mailto:yuesheng8@gmail.com">yuesheng8@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have a table with 700million rows, and 14 columns. All doubles. Each column of data have non-unique entries. No indexing. <div><br></div><div>My query: </div><div><br></div><div>SELECT * FROM bigtable WHERE col4 &lt; 1000 limit 100;</div>

<div><br></div><div>took 35 minutes to run. </div><div><br></div><div>(a) Is this about the average time to run?</div><div>(b) Should I explicitly index col4? (Website seems to suggest MonetDB takes care of indexing automatically) If so, how much benefit should I expect?</div>

<div><br></div><div>Thanks.</div>
<br>------------------------------------------------------------------------------<br>
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are<br>
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and<br>
easily build your RIAs with Flex Builder, the Eclipse(TM)based development<br>
software that enables intelligent coding and step-through debugging.<br>
Download the free 60 day trial. <a href="http://p.sf.net/sfu/www-adobe-com" target="_blank">http://p.sf.net/sfu/www-adobe-com</a><br>_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
<br></blockquote></div><br>