Assume we have billions of rows:
Fine Grained Update :
- 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.
- Update each record of billion of records separately.
Coarse Grained Update :
- Some applications would have a need to update all these billions of rows and apply the same update logic.
- Update billion of records using same function is a Coarse Grained Update.