Message-Id: <10506.106347@fatcity.com> From: "Walter K." Date: Tue, 23 May 2000 06:39:50 -0500 Subject: COPY vs. INSERT This is a multi-part message in MIME format. ------=_NextPart_000_0022_01BFC481.B243DB40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, 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_0022_01BFC481.B243DB40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

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_0022_01BFC481.B243DB40-- __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger.