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.
