Order by Statement Performance Issue

• joemai

  Hall of Fame

  Points: 3496

  More actions

  June 5, 2007 at 1:47 pm

  #179106

  Hi All,

  Do you have another way to go around with this? The order by  statement caused the bottlenect in my queries as I analyzed them.  Is there anyway to make the improvements for the queries which have 'order by' statements.

  Thanks in advance for any ideas.

  Minh Vu

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  June 5, 2007 at 1:48 pm

  #710945

  Set a clustered index on the column(s) mentioned in ORDER BY.

  _____________
  Code for TallyGenerator