Post reply

performance is on select query which use function

  • 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.

  • 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;-)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply