Does SQL server execute a with statement if it is not used? : I'm trying to debug a query that is performing slowly. It has several `with` statements which are `left joined`. When I remove the joins, it speeds up considerably. Is it safe to assume there is an issue with the joins, or does it skip the `with` if the `with` variables are never called? 