Post reply

Query re-write application

  • April 29, 2013 at 10:32 am

    #394688

    Just wondering if anyone knows of a application that can intercept a certain query on the fly and re-write it? We have a troublesome query in our application that uses an INNER LOOP JOIN that the vendor has not been able to correct. It is dynamic and embedded deeply in their code. I just need to remove the LOOP keyword and the query flies. Thank you!

  • April 29, 2013 at 10:39 am

    #1610909

    Try a plan guide, you may be able to overrule the join hint with another, though you will have to work out what the optimal join is and keep testing to make sure it doesn't change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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