Which one is faster :

  1. query from a cte
  2. query from a view

(in Complex Queries). I have a complex query and i have another complex query from the first one.Is it faster to create a view for the first complex query and query from the view or use cte?

sql-server performance
Edit
Report