"Insert into ... select from ..." takes too long

[dougclind]

Addendum to post:

For some reason the forum chopped out the text after the "select" word in my query. All it was is this simple list of fields being selected from both tables:

s.SHIFTNUMBER, h.START_TIME_LCL, h.END_TIME_LCL, 'AT', h.PROJECT_NUM