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>