Re: Help with insert query

On 4/1/19 12:37 PM, Glenn Schultz wrote:
> All,
>
> The query below is designed to insert into a table.  This works when I 
> have a single loan which I insert. However, if remove the part of the 
> where clause of a single loan the insert does not work.  The table fnmloan 
> is a large table with 500mm + rows and the query runs for about 4 hours. 
> Any idea of how to get this to work?  I am a little stumped since the 
> query works with one loan.

Following up to Michael's answer... 500MM rows in 4 hours is an insert rate 
of 34,722.222... records per second.

-- 
Angular momentum makes the world go 'round.