Browse Teach Curate

Table Partitioning

Partitioning splits one logical table into physical child tables by ranges, lists, or hashes of a partition key, so maintenance, indexes, and scans operate per-partition. It shines for time-series retention (drop a partition instead of DELETE) and for confining hot data to small partitions.

Questions this Concept answers

Why is detaching an old partition cheaper than deleting the same rows?

jeremy Video

Partitioning a Large Table by Date Range in SQL Server

Table partitioning divides one logical table into physically separate partitions according to the values of a partitioning key, so that the table still presents itself to clients as a single object w…