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 ways.
Alan. On Thu, Jan 24, 2019 at 2:08 AM Shivam Sharma <28shivamsha...@gmail.com> wrote: > 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 > <https://www.linkedin.com/in/28shivamsharma>* >
