• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to improve update performance in SQL server 2005?

 
soumya dash
Greenhorn
Posts: 14
Eclipse IDE Java MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to speed up my update in SQL server 2005.

1.I have clustered the indexes used and dropped unused ones.

2.I have used join instead of sub query.


Any other suggestion to improve the performance?
 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think anyone trying to help you will need more information. database optimization is a big subject.

How big is/are the table(s) you need to update? What does the actual SQL query look like (post the code).

are you sure there is a performance problem on the database side and not in the code? Do you have any tools that break down the database steps so you can see where it is taking too long? How did you decide which indexes are not being used, from an explain plan? Are you able to change the database around (denormalize) if needed?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic