More time on Standard Edition

• rosh-396756

  SSCrazy

  Points: 2338

  More actions

  December 8, 2008 at 5:20 am

  #196714

  We have a situation wherin a query takes more time on a Standard Edition than on a Developer Edition. The databases are same. Execution Plans are same.

  What could be the reason for this?

  Both are developer environments.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 8, 2008 at 7:20 am

  #909126

  Statistics in the database could be different. Are the server specs the same? You could have less memory or slower disks.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question