[MonetDB-users] monetdb--query is very slow on table about 1 billion rows

hi, guys, i create a simple table , and the table is up to 1 billion rows, its structure as follow: create table test(Month_ID int not null, C_NAME varchar(10) not null, C_ID int not null, MSISDN varchar(15) not null, C_FLUX double not null); and the data looks like: “201201，name1, 123213, 13723213213, 12.12321" when i execute the query "select c_name,c_flux from test where c_id=**** order by c_flux desc", it takes more than 3 minute to get the result(more than 100 thousands rows returned, if limit 100 is used, the execute time is about 40s), is there any ways to optimize? Hardwares: intel xeon 2.12*8, 32G memory, 4*1T SATA(raid 0)