Pythonist
Pythonist

Reputation: 85

does clustering granularity fields in merge statement will improve the statement performance in bigquery?

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

Answers (0)

Related Questions