COPY command works faster when all the columns are selected. However, it will run slowly when a sub set of columns is selected.
CTAS ( create table as select) is much desirable options by developers because it can be done in parallel.
|
Results 1 to 10 of 17
Thread: Why use the 'copy' command?Threaded View
|
Click Here to Expand Forum to Full Width |