SQL Server Performance

How to remove view replace with direct table

Discussion in 'Analysis Services/Data Warehousing' started by ilyas, May 7, 2005.

  1. ilyas New Member

    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?

  2. derrickleggett New Member

    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
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. dineshasanka Moderator

    You can gain the perfomance by the indexing the view.
    And also as derrick said check the execution plan
  4. Raulie New Member

    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

Share This Page