The only way to be sure is to test. See what columns in your temp table are being used to perform the updates (hopefully a single column), then weigh the cost of creating an index on that column against the time you'll have in doing your updates. If you're using a single column for multiple updates in your 1400-line procedure, you'll likely benefit from indexing it. Again, testing it both ways is the only way to be sure.