View slow in 2005

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  February 17, 2010 at 7:07 am

  #156682

  Hi friends,

  We upgraded SQl server from 2000 to 2005, everything looks fine but just the one view is taking too long. View is doing a full outer joining on 2 tables, pretty much straight forward query. We initially had RTM version of sql server, I now upgraded to SQl server SP3 hoping it will help.. But still the same.. Any suggestions please? Do I need to install cumulative updates for Sp3 as well?

  Thank you

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 17, 2010 at 7:17 am

  #1120063

  Have you updated all statistics ?

  ---

  
  Clear Sky SQL
  My Blog[/url]

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  February 17, 2010 at 8:19 am

  #1120131

  Yes.. database is set to autocreate statistics to true and auto update statistics to true..

  Thanks

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 17, 2010 at 9:19 am

  #1120182

  Nether the less , its is best practice to manually update statistics after an upgrade.

  If that doesnt help then follow the links in my sig for how to help us to help you

  ---

  
  Clear Sky SQL
  My Blog[/url]

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  February 17, 2010 at 9:48 am

  #1120209

  See my and other responses in this similar thread:

  http://www.sqlservercentral.com/Forums/Topic809627-149-1.aspx