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
Last activity: Jul 28, 2025, 04:48 AM