Access frequency and required query latency drive the decision. Hot-tier data supports real-time dashboards and alerting where latency must stay under a second; cold-tier data handles compliance audits or forensic investigations where a longer wait is acceptable. Most teams implement this with time-based policies, automatically moving data after 30 days to warm and after 90 days to cold, then adjust those thresholds based on observed query patterns.