View Single Post
  #3 (permalink)  
Old 07-22-10, 08:17
dav1mo dav1mo is offline
Registered User
 
Join Date: Dec 2007
Location: Richmond, VA
Posts: 782
If trying to speed things up, why in the world would you insert to a temp table??? Work should be done on the query to alter the problem that is slowing things down so much. As the prior poster already suggested look at the plan and see how the tables are being accessed. If still continuing to have issues, post the SQL and we may be able to offer some suggestions.
Dave
Reply With Quote