-
Slow update
Hi
I have a table with only 15,000 records and i need to update all the records to increment by 1 every min, therefore a full scan on the table is neccessary. However, the update is very slow!!
I did a timing and it can takes up to 2 mins to update all the records! Is there any ways which I can improve the perofrmance of the updates??
Thank you!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|