Hi team,

I am running monetdb on 16 core processor and 30gb ram.

I have table around 54 fields. gzip compressed csv size is around 6.5 GB.

query will take around 6 min. please suggest tuning options.

query:

Select count(distinct userid),sum(mrp)/sum(noOfItems),sum(mrp)/sum(orderCount),sum(revenue),sum(orderCount),sumnoOfItems),sum(returnCount),sum(rtoCount),sum(0),sum(0),sum(tDiscountPer),sum(cDiscountPer) from historical where gender='men' and brand='puma'

Thanks and

Regards

Rajendra Bhat

Thanks and
Regards

Rajendra Bhat