Creating A Composite Index Using Ancestral Keys In A Hierarchical Database Table Design

added by JavaScript Kicks
6/24/2019 12:30:36 PM

151 Views

Ben Nadel shares an idea for creating composite keys that contain all of the slow-changing ancestral IDs in a hierarchical database model. This set of trade-offs favors fast read-access at the expense of slower write-access, while also making some types of mutation queries much more straightforward and other types of aggregation algorithms much more performant.


0 comments