Memoizing Nodes in Recursive CTE Queries for Efficient Graph Traversal

Using UNION vs UNION ALL in Recursive CTEs: When to Make a Difference in Database Performance and Readability.