Does putting a clustering key impact the bulk copy performance? For example if I have a large table and I am loading data into it. and it has 2 clustering key in it. does removing the clustering key helps in loading the file faster. or since clustering is an automated process, It happens in backend. say for example snowflake loads the data first and after that it does the clustering in backend while data is already available to use.
>Solution :
No, it does not affect bulk copy performance.
since clustering is an automated process, It happens in backend. say
for example snowflake loads the data first and after that it does the
clustering in backend while data is already available to use.
Yes, it is exactly how it works.