will grouping take lot of time?

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  October 15, 2009 at 8:57 am

  #385586

  What wrong or time consuming thing in this query ? GROUP BY UPPER(C3), UPPER(C4)?

  NO OF ROW 500k+

  Select

  Max(C1),

  Min(C2),

  UPPER(C3),

  UPPER(C4),

  SUM(C5),

  Max(C6),

  Min(C7)

  FROM table1

  where C8 < 1 AND C3 IS NOT NULL

  GROUP BY UPPER(C3),

  UPPER(C4)

• dbo.benyos

  SSCommitted

  Points: 1944

  More actions

  October 15, 2009 at 9:43 am

  #1066356

  It could be anything - from indexes to using the UPPER() function...

  I'd start with removing the 'UPPER' function and see if it makes any big difference.

  If not - look at the query plan and see what SQL is doing in the background.

  Tal Ben Yosef
  www.TalBenYosef.com
  (visit my LinkedIn profile)