Highlight the advantages of PPI(Partition Primary Index).

DWQA QuestionsCategory: QuestionsHighlight the advantages of PPI(Partition Primary Index).
Editor Staff asked 1 month ago

Highlight the advantages of PPI(Partition Primary Index).

1 Answers
Editor Staff answered 1 month ago

PPI is basically used for Range-based or Category-based data storage purposes. When it comes to Range queries, there is no need of Full table scan utilization as it straightaway moves to the consequent partition thus skipping all the other partitions.