Fine v/s Coarse Grained Update

Assume we have billions of rows:

Fine Grained Update :  

  1. Some applications have to identify a unique record in billions of records and update them, each update would be a different update logic this is called Fine Grained Update.
  2. Update each record of billion of records separately.

Coarse Grained Update

  1. Some applications would have a need to update all these billions of rows and apply the same update logic.
  2. Update billion of records using same function is a Coarse Grained Update.