File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes how to improve update performance in SQL server 2005? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to improve update performance in SQL server 2005?" Watch "how to improve update performance in SQL server 2005?" New topic
Author

how to improve update performance in SQL server 2005?

soumya dash
Greenhorn

Joined: Jul 17, 2012
Posts: 14

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

Joined: Apr 30, 2003
Posts: 820

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?
 
 
subject: how to improve update performance in SQL server 2005?