Skip to content

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


After seeing many with clauses in the scripts in my project, even I tried to getting used to it (without knowing the power of cte). I had a chance to work with an oracle architect. That time he made me realize the power of cte. He tunned a query which was running 250 seconds long to just 2 seconds. After going through the modifications I learned something. With that after some days I tunned a query which was running for more than an hour to 8 minutes. It's very very powerful tool if it is used properly.

code of conduct - report abuse