Optimize sql query

Looker Q&A Looker
,
1 
Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I run sum measure it takes 20 min to displayMy database is bigquery

explore: store {
  join: dv_purchase {
    type: left_outer
    relationship: one_to_many
    sql_on: ${store.id_store}=${dv_purchase.id_store} ;;
  }

  join: dig_orders {
    type: left_outer
    relationship: one_to_many
    sql_on: ${store.cd_store}=${dig_orders.cd_store} ;;
  }
}