SQL Performance improvement

  1. Make sure there are indexes available.
  2. Not too much denormalization. The joins cause performance problems.
  3. Are triggers causing an insert operation?
  4. Select only the columns needed.

Leave a Reply

You must be logged in to post a comment.