How to remove view replace with direct table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to remove view replace with direct table

A SQL Server view is taking 4 hours to read data as a part of data warehouse build. Anybody could help me how to improve this view or hoe to create a direct table with index to improve the performance?
Have you looked at the execution plan for the statements that read from this view to see if it’s doing table scans, etc? Have you looked at the process in Profiler to see reads, etc? Can you post the CREATE statement for the view? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
You can gain the perfomance by the indexing the view.
And also as derrick said check the execution plan
Another thing I found useful is if your server uses SMP, try turning off Parallelism with the OPTION(MAXDOP1) query hint then run your query. Raulie
hp
]]>