Your company's BigQuery table, customer_order
, contains order history for 10 million customers, totaling 10 PB in size. To enhance the support team's dashboard performance with filters on country_name
and username
, how should you optimize the table design?