CTE’s in some environments are actually extremely taxing on the resources. Distributed processing platforms like Redshift are forced to copy the CTE to every node involved the query which when you are dealing with hundreds of millions of rows of data SLOWS the query down.
I ban the use of CTE in our production code and only allow them when people are querying away.
Great article !!
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Yes 100000000000000% this.
CTE’s in some environments are actually extremely taxing on the resources. Distributed processing platforms like Redshift are forced to copy the CTE to every node involved the query which when you are dealing with hundreds of millions of rows of data SLOWS the query down.
I ban the use of CTE in our production code and only allow them when people are querying away.
Great article !!