Sql, Technology, Programming, Machine Learning, Data Science.
Once the load is done, recreate the indexes on the table. Avoid too many subquery or CTE joins Joining many subqueries or CTE’s might lead to holding all the rows in memory and requires constant spilling of data to disk in order to facilitate the join operation and it takes a long time to finish