Microsoft SQL 2016 – Insert INTO #TempTable is fast but SELECT * FROM #TempTable is very slow, why and how to improve performance?
I need to insert into temp table “#Temp” 300 000 rows and 30 columns from different tables, I created indexes and inserting is very fast, it needs about 3 seconds. But then, when I want to read from this temp table it takes very long – about 3 minutes, can I do something for speed up this process?