In database operations, especially when performing joins, it's often more efficient to scan the tables and store intermediate results in temporary tables $($Temp T$1$ and Temp T$2).$ This helps in reducing the number of scans needed on the original large tables and makes the join operations faster. Please explain when i should use temporary tables and when not.