Skip to content
loading...

re: SQL 201: Why you should use SQL CTEs VIEW POST

FULL DISCUSSION
 

All my objections to the article were covered by other respondents, save one.

Is it really a valid argument that CTE improves readability? There are serious limitations of that functionality...

I'm not pro nor con CTE - as everything it has it's uses, but more often than not I encounter a POV - mostly from analysts of all sorts and stripes - that states: "CTE is easier to read than subquery" or similar. I don't believe that this ever should be any serious argument for (or against) any solution, let alone one that can - if written badly - bring entire server to it's knees...

I also recently encountered a POV that one should ditch temp tables in favor of CTEs because "temptables are outdated".

My personal opinion is that if you use either CTE, subquery or Temptable to make complicated code more readable or manageable, and you are an analyst, then your query could use overhaul...

code of conduct - report abuse