Re: [Monetdb-developers] Bug report: Poor query performance

2008-08-31 Thread Martin Kersten
Elad . wrote: > > Hi, > > I have a database with 52 columns and 7 million rows. dear Elad, Thanks for using MonetDB. The problem you describe is known. No easy solution exists, because the front-end optimizer does not use, nor rely on table statistics to derive the best plan. A solution will

[Monetdb-developers] Bug report: Poor query performance

2008-08-31 Thread Elad .
Hi, I have a database with 52 columns and 7 million rows. The columns are Date (timestamp data type), Customer (real data type) and a bunch of other columns that indicate values for each customer on each date (all of these columns are of real data type). The 'Date' column contains 5 uniqu