This discussion is archived
10 Replies Latest reply: Nov 29, 2012 1:25 PM by jgarry RSS

Performance Tunning

976982 Newbie
Currently Being Moderated
Hi guys,

I have to update a table containing 22 miillion records(with duplicates no key column). where the update record count will be around 6 lakhs.
would you please suggest me a better way to write update procedure. I implemented primary steps like index creation. please post any other advance concepts..or methods.

Thanks in advance

Edited by: 973979 on Nov 29, 2012 4:57 AM

Edited by: 973979 on Nov 29, 2012 5:00 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points