Saved Bookmarks
| 1. |
What Is The Difference Between Static Cache And Dynamic Cache? |
|
Answer» In case of DYNAMIC cache, when we are inserting a new ROW it checks the LOOKUP cache to see if it EXISTS, if not inserts it into the target as well as the cache but in case of static cache the new row is written only in the target and not the lookup cache. The lookup cache remains static and does not change during the session but INCASE of dynamic cache the server inserts, updates in the cache during session. In case of dynamic cache, when we are inserting a new row it checks the lookup cache to see if it exists, if not inserts it into the target as well as the cache but in case of static cache the new row is written only in the target and not the lookup cache. The lookup cache remains static and does not change during the session but incase of dynamic cache the server inserts, updates in the cache during session. |
|