Vertical & Horizontal Partitioning, Join & Hash Indexes and PPI?

PPI does not support any join index and hash index

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.