DEV Community

Discussion on: How to write SQL recursive CTE in 5 steps

Collapse
 
alfiqmiq profile image
Marek • Edited

Always good to include hints in query (example for MySQL):
WITH
...
SELECT /*+MAX_EXECUTION_TIME(1000) SET_VAR(CTE_MAX_RECURSION_DEPTH=100)*/
...