sureshkuncham

• Nov 16th, 2012

 

PPI does not support any join index and hash index

yuvaevergreen

• May 20th, 2013

 

Horizontal partitioning is used in large tables where no of rows are very high. Rows are broken and placed in partitions. Loading becomes faster and query performance would be good.

Vertical partitioning is used for tables with huge no of columns. Column wise data are broken and placed in partitions with a common key.

A multi/aggregate join index basically stores the results of the join in perm space.
A hash index basically stores the results of the table based on the hash value.

PPI basically partitions the data based on the column that is specified in the partition clause.