DISQUS

devrobboek: UPDATE Statements and Indexes

  • Walter · 5 months ago
    Hey, I couldn't find an email address for you so I decided to leave a comment instead. Would you like to trade links? let me know, Thanks!
  • Denis Langlais · 7 months ago
    Some people might say "dynamic sql" is worse than
    multiple index update
  • Rob Boek · 7 months ago
    Dynamic SQL is only one option. As I said in the post, you can create multiple procedures to handle the most frequently updated value combinations.