fastest aggregation method needed

[#1]

Hi ppl ,

Load Shop_id,city,  min(orderdate) as start_date, max(orderdate) as end_date

Resident orders_table

group by shop_id,city;

this load is taking half an hour can you people help me to reduce the load time its has  50 million records.

Thanks in advance.

[sunny_talwar]

May be using a for loop with this https://qlikviewcookbook.com/2015/05/better-calendar-scripts/