Re: General Question: UNION version multiple INSERTS

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 16 Oct 2006 04:46:02 GMT
Message-ID: <J77p8v.8Mt@igsrsparc2.er.usgs.gov>

Dereck L. Dietz wrote:
> In general, which is more efficient to put data into a table?
>
> 1. Multiple UNION statements or
>
> 2. Multiple INSERT statements
>
>

Option 2 is much more efficient for putting data into a table. This is because the UNION clause will not put any data into any table.

Cheers!
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Sun Oct 15 2006 - 23:46:02 CDT