query optimization

• smoham22

  Mr or Mrs. 500

  Points: 525

  More actions

  April 1, 2020 at 3:45 am

  #3739505

   

   

  • This topic was modified 5 years, 5 months ago by smoham22.

• pietlinden

  SSC Guru

  Points: 63594

  More actions

  April 1, 2020 at 4:09 am

  #3739508

  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 5 years, 5 months ago by pietlinden. Reason: additional info