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.