Post reply

which one SQL query gives me the Faster Output

  • July 24, 2009 at 12:28 pm

    #73881

    Dear Friend,

    i need your help...

    which one SQL query gives me the Faster Output from below...

    1). select Auditdata.* from auditdata auditdata

    inner join Circlemaster c_mst on

    auditdata.circlemaster_id<>C_mst.circlmaster_id

    where tatcalltype is null

    or

    2). select Auditdata.* from auditdata auditdata

    inner join Circlemaster c_mst on

    auditdata.circlemaster_id not like C_mst.circlmaster_id

    where tatcalltype is null

  • July 24, 2009 at 12:30 pm

    #1029966

    the should. The LIKE operation tends to be expensive..

    Also, why don't you test it an tell us..

    CEWII

  • July 24, 2009 at 1:12 pm

    #1030004

    duplicate post.

    please continue here .


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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