A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?
Posted: Fri Aug 26, 2022 10:01 am
A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?
A. Use a CURSOR.
B. Use an EXTERNAL table.
C. Use the COPY command.
D. Increase the PreFetch Count.
A. Use a CURSOR.
B. Use an EXTERNAL table.
C. Use the COPY command.
D. Increase the PreFetch Count.