high latency

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.code_store} ;;
  }
}
2

I would take a guess that you are missing a join key, maybe orderid on the orders join.

3

@IanT join keys are correct