title: WITH Common Table Expression vs. CREATE VIEW performance
body: <p>I have several queries that use a WITH clause, or Common Table Expression, with a UNION ALL statement to recur through a table with a tree like structure in SQL server as described <a href="http://www.webinade.com/web-development/creating-recursive-sql-calls-for-tables-with-parent-child-relationships" rel="nofollow noreferrer">here</a>.  Would I see a difference in performance if I were to CREATE that same VIEW instead of including it with the WITH clause and having it generated every time I run the query?  Would it generally be considered good practice to actually CREATE the view since it is used in several queries?</p>