aspose 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
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to improve update performance in SQL server 2005?
 
Similar Threads
Is there a necessity in writing SQL queries in xml file
Hibernate : JDBC Driver
preparedstatement advantage (jdbc experts)
a q about SQL Server 2005 DB and Java
count number of coulmns in table?