I am at a loss. a select on a view returns 82000 rows in 30 seconds but if i place insert before it
returns 82000 rows in 30 seconds but if i place insert before it, it takes 15 minutes. i ran sqlt xtract and what jumped out was that the insert appear to be processing a much higher number of rows. the execution plan seems to be the same which is baffling. i figure this to be a common process but have been unable to come up with an explanation from my research. i am attaching info on the query and screenshots from the sqlt monitor report. thanks in advance. cheers