performance is on select query which use function

• k.thanigaivel

  Ten Centuries

  Points: 1247

  More actions

  March 2, 2011 at 9:31 pm

  #232924

  Dear all,

  we have used on select query, for example

  select dbo.funFactor(a.testid) ... from TestingResult a join....

  the above query takes more time and we found it comes under top querylist. is it good practice? if not please give the alernate way for the same.

  thanks lot.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 3, 2011 at 5:26 am

  #1293933

  Post the query along with table index definitions

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)