1. Partition Primary Index(PPI) occupies extra two bytes for storing partition number.
2. Partition Primary index cannot be created on volatile and Global Temporary tables and compressed join index.
3. PPI does not allow NUPI, allows only UPI if PPI is part of primary index. Because in case of NUPI, it would require checking for a duplicate key value in every partition, which would be very expensive. But in case of UPI,This will result in checking for unique constraint in the same partition.
2. Partition Primary index cannot be created on volatile and Global Temporary tables and compressed join index.
3. PPI does not allow NUPI, allows only UPI if PPI is part of primary index. Because in case of NUPI, it would require checking for a duplicate key value in every partition, which would be very expensive. But in case of UPI,This will result in checking for unique constraint in the same partition.
No comments:
Post a Comment