query optimization

  • smoham22

    Mr or Mrs. 500

    Points: 525



    • This topic was modified 2 months ago by  smoham22.
  • pietlinden

    SSC Guru

    Points: 62780

    WITH (nolock) isn't a magic "go faster" button. It's allowing dirty reads. If you want it to read faster, index the columns in the joins and the filters.

    We don't even know what your query is supposed to do, and we don't have any scripts for the tables involved. Is this a game of pin the tail on the donkey?

    Maybe read this

    • This reply was modified 2 months ago by  pietlinden. Reason: additional info

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

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