Hierarchical partition keys: when to use them and how queries route
This sheet compares Leading prefix filter, Middle level only, All levels specified.
| Criterion | Leading prefix filter | Middle level only | All levels specified |
|---|---|---|---|
| Example | WHERE TenantId = x | WHERE UserId = x (no TenantId) | TenantId + UserId + SessionId |
The verdict, the full comparison, 6 rules and 3 traps are part of DP-420 access. Unlock DP-420.