24 Apr 2013

What is Advantage of PPI?


Mainly we use for Range based data storing or category based Data storing.
Range queries don't have to utilize a Full Table Scan.Its directly goes to the corresponding partition and skips other partitions.
Fastload and Multiload work with PPI tables, but not with all Secondary Indexes.

No comments:

Post a Comment