executing a sql server view vs running code in view

Question

Hi,

I have a view that was created in SQL Server. The view has about 20 joins some CTE's and a union. The code within the view runs and returns results in about 4-5 minutes. However, if I do a select * from the the view or select [column names] from the view, it doesn't finish. I let it run for 90 minutes and it never comes back with any results.

Any idea why the code within the view works but selecting from the view does not?

thanks

Answer 1

Hi @Scott Cabral ,

I watched the whole thread，executing a sql server view vs running code in view ，should be the same.So could you provide us with the code and execution plan so that the experts can do some tests?

Echo

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table

Answer 2

I'm having issues creating the execution plan in the database. I will need to have our DBA's take a look, but it could be a permissions issue.