This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: how to improve update performance in SQL server 2005?
 
Similar Threads
preparedstatement advantage (jdbc experts)
Hibernate : JDBC Driver
Is there a necessity in writing SQL queries in xml file
count number of coulmns in table?
a q about SQL Server 2005 DB and Java