report running slow

• natalie_orlovsky

  Mr or Mrs. 500

  Points: 535

  More actions

  September 27, 2010 at 7:16 pm

  #227086

  Hi gurus,

  I have report which running very slow,because it using complicated view.Actually it not that complicated ,but it UNION 2 huge tables.My question is how I can improve the performance.It is any way to put index on view like this?

  I try today ,no luck.

  Thanks in advance

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 28, 2010 at 1:18 am

  #1228175

  Please see this page

  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

  
  Clear Sky SQL
  My Blog[/url]

• natalie_orlovsky

  Mr or Mrs. 500

  Points: 535

  More actions

  September 28, 2010 at 7:34 pm

  #1228732

  Thanks ,

  it was very helpfull