Re: Difference in performance of temp table vs subqueries

That's a broad question and it depends on what you're doing. Since temp tables will materialize the intermediate result while subqueries will not I'd guess in most cases subqueries are faster. But again, it depends on what you're doing, and you'd need to benchmark your particular queries both

Difference in performance of temp table vs subqueries

Hi All, As per subject of mail, I want to know performance difference in both subquery and temp table. Thanks -- Shivam Sharma Indian Institute Of Information Technology, Design and Manufacturing Jabalpur Email:- 28shivamsha...@gmail.com LinkedIn:-*https://www.linkedin.com/in/28shivamsharma

Difference in performance of temp table vs subqueries

Hi All, As per subject of mail, I want to know performance difference in both subquery and temp table. Thanks -- Shivam Sharma Indian Institute Of Information Technology, Design and Manufacturing Jabalpur Email:- 28shivamsha...@gmail.com LinkedIn:-*https://www.linkedin.com/in/28shivamsharma