SQL Practice Logo

SQLPractice Online

Level 6 - ExpertScenario-Based Questionsm2 performance schema

Scenario: Hot/Cold Order Table Split

You need low latency for recent orders and cheap storage for old orders. Propose SQL table strategy for hot and cold data with unioned read path.