Sample Header Ad - 728x90

Partitioning heaps - Why?

3 votes
2 answers
499 views
I know, at least theoretically, that heap tables can be partitioned. As I learn more about table partitioning, I realise that the use case is very limited. Similarly, the use case for heaps in SQL Server is also very limited. Whenever I intersect my list of heap use cases and partitioning use cases, I find myself with an empty list. Are there any sets of circumstances where a partitioned heap would appear strongly desirable?
Asked by J. Mini (1225 rep)
Jul 26, 2025, 11:37 PM
Last activity: Jul 28, 2025, 04:48 AM