Dealing With Ambiguous Scenarios
The previous scenarios illustrate situations where a row‑partitioned table is the obvious choice to enhance the performance of a query workload. This scenario examines a more ambiguous situation in which there are more tradeoff considerations and it is not possible to determine in advance one correct solution for all specific instances of the scenario.