With CTE is same like temp tables?

Question

I am using "WITH CTE" inside my trigger. So if many users came into my web app, does the performance will be slow. Droping will be automatically happen. Will creation and droping of CTE is more costlier. Is is advisable?

How much can i store using WITH CTE?

Is it same like TEMPORARY TABLE?

score 1 · Answer 1 · edited May 23 '17 at 12:29

1

A CTE is not a temp table, it's basically a subquery or derived table.

Using a CTE can make your code easier to read

There are some good answers on this question

edited May 23 '17 at 12:29

Community

1
1

answered Jan 29 '11 at 23:22

gbn

422,506
82
585
676

With CTE is same like temp tables?

1 Answers1