[MonetDB-users] Billions of rows

Hi

From one big dataset, we already have 0.7 billion rows. And we are looking at having 100 datasets eventually over the period of a year. That's 70 billion rows. From what I understand, column data are loaded into virtual address space, then dynamically indexed for querying? Does that mean that on a query "SELECT a FROM table WHERE b = N", it'd have to load all of 70 billion values of b, index, then provide results for a? Is this a case where statically created index would help? Does MonetDB use static created index?

Thanks, Benjie