Advantages of Partition Primary Index

· Range queries eliminates the use of Full Table Scan.
· PPI is an alternate to secondary index, it provides an excellent solution compared to secondary indexes
. PPI can make modeling and querying easier.
· We can't use fastload and multiload with all secondary indexes, But we an  use Fastload and Multiload work with PPI tables.


1 comment:

  1. There are some hurts that we experience that can be
    forgiven but we won't forget them. See the link below for more info.


    #hurts
    www.inspgift.com

    ReplyDelete