Forum Post: Re: Improving The Performance Of Query

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
Posting in multiple forums isn't going to help you get this answered quicker. I don't understand your question though. Why do you think you need a share lock? Share locks should be avoided at all costs. This query should be done with NO-LOCK. How many records are in xmm012? You're reading all of them.

Continue reading...
 
Status
Not open for further replies.
Back
Top