What can be done to make this faster?

seenagape

10 years ago

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.

Explanation: