Question

Optimize sql query

  • 11 February 2021
  • 0 replies
  • 9 views

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} ;;
}
}

 


0 replies

Be the first to reply!

Reply