When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?
When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?
The performance of executing a COPY INTO command can be negatively affected by using the PATTERN optional parameter on a large number of files. This is because applying patterns to filter files can lead to performance overhead due to the additional processing required to evaluate and match the pattern against each file.
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table
B. PATTERN is correct
The correct answer is B. Pattern For the best performance, try to avoid applying patterns that filter on a large number of files. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#:~:text=paths%20to%20match.-,Tip,-For%20the%20best
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#:~:text=For%20the%20best%20performance%2C%20try%20to%20avoid%20applying%20patterns%20that%20filter%20on%20a%20large%20number%20of%20files.
B - PATTERN