page160
143
Summary
In this chapter, I covered micro-partitions and different ways to identify the number of
micro-partitions belonging to an object.
I then explained how time affects micro-partition observability along with a
discourse on the idealized micro-partition life cycle.
Stepping through the traditional segments of an application life cycle illustrated
the impact of incorrectly setting data retention periods. I then provided justification for
using transient tables for specific components within your applications.
Our investigation into Time Travel, Fail-Safe, and cloning demonstrated hidden
storage costs incurred by micro-partition retention. I then identified some challenges
with uncontrolled cloning and made recommendations to mitigate such actions.
With a firm grasp of micro-partitions, appropriate object creation, use, and
maintenance, I will next discuss cluster keys.
ChaPTer 4
MiCro-ParTiTionS