Message-Id: <10505.106243@fatcity.com> From: "Walter K." Date: Mon, 22 May 2000 10:54:45 -0500 Subject: COPY vs. INSERT This is a multi-part message in MIME format. ------=_NextPart_000_002D_01BFC3DC.23F28120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Which is more efficient, to populate a table via a standard INSERT = command or using the SQL*Plus COPY command? Has anyone tried to = benchmark the two? What are the pros/cons of each? The table to be = populated will always need to be appended to, never truncated. Thanks in advance for the advice. -wk ------=_NextPart_000_002D_01BFC3DC.23F28120 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Which is more efficient, to populate a = table via a=20 standard INSERT command or using the SQL*Plus COPY command? Has anyone = tried to=20 benchmark the two? What are the pros/cons of each? The table to be = populated=20 will always need to be appended to, never truncated.

Thanks in advance for the = advice.

-wk

------=_NextPart_000_002D_01BFC3DC.23F28120-- __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger.