Table Partitioning

Problem

You have a logging database with billions of rows. Queries for the current day are slow because it scans the entire history. You decide to break the table into smaller physical tables based on the date. Write a query that outputs concept with the value: "Table partitioning divides a single logical table into multiple smaller physical tables based on a partition key like date range."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution