When to use temp table?
1571
18-Sep-2017
Updated on 22-Sep-2020
Sushant Mishra
18-Sep-2017We can use temp table when we are doing large number of row manipulation in stored procedures.
Temp table can be when we want to replace the cursor we can store the result set data into a temp table then we can manipulate the data from there.
We can use temp table when we are having a complex join operation.