Reputation: 85
I have a big target table that should be merged with small table every day.
lets say the granularity fields are x,y,z
i.e
merge t1 using t2 on (t1.x=t2.x and t1.y=t2.y and t1.z=t2.z)
will it help me to cluster t1 table by one of the granularity fields? does bigquery know how to use the clustering adventage in merge statements?
I couldnt find any official documentation about it.
Upvotes: 0
Views: 249