![sql server - Why doesn't this recursive CTE with a parameter use an index when it does with a literal? - Database Administrators Stack Exchange sql server - Why doesn't this recursive CTE with a parameter use an index when it does with a literal? - Database Administrators Stack Exchange](https://i.stack.imgur.com/uHkeY.png)
sql server - Why doesn't this recursive CTE with a parameter use an index when it does with a literal? - Database Administrators Stack Exchange
![SQL SERVER - Introduction to Hierarchical Query using a Recursive CTE - A Primer - SQL Authority with Pinal Dave SQL SERVER - Introduction to Hierarchical Query using a Recursive CTE - A Primer - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/j2p-day2-image-1.png)
SQL SERVER - Introduction to Hierarchical Query using a Recursive CTE - A Primer - SQL Authority with Pinal Dave
![SQL SERVER - Introduction to Hierarchical Query using a Recursive CTE - A Primer - SQL Authority with Pinal Dave SQL SERVER - Introduction to Hierarchical Query using a Recursive CTE - A Primer - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/j2p-day2-image-4.png)