Mar 08, 2019 10:25 PM|MikeT89|LINK
I am trying to update over 10 columns in a table that contains over a million rows. The source data are coming from multiple tables which requires me to join about 13 tables.
My query run super slow about 1hr and 30 mins.
My question is, would it be better to store all the columns I need into a temp table and do all my joins there or use a cte, then use the temp table or cte to update that actual table?
I'm trying to find a way to make my query faster.