Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

Answers


Common Table exp ression (CTE in SQL) is a temporary result set that, derived from query (T-SQL query in MS SQL Server) And defined within the execution scope of a Select, Insert, Update, Delete statement.

Some disadvantages or cons using CTE

1. CTE cannot be nested like views.

2. Not possible to reuse in another query like view or function, reason a CTE is just shorthand for a query or subquery.

3. Possible performance issue in case of frequently used query(If CTE is used in that query).

Note:

in follwing thread shared some advantges using CTE

https://codechef4u.com/post/2019/04/11/What-are-the-Advantages-of-Using-CTE-in-the-SQL-server

Share your answer


Share as a guest

Please subscribe me to the CodeChef4U.

By creating your new answer, you agree to the privacy policy and terms of service.