Submitted Questions

  • Feb 23 2010
    02:14 AM
    13800
    6

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

    What are the differences between the followings?- Vertical & Horizontal Partitioningvs- Join & Hash Indexes vs- PPI

    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 partitio...

    sureshkuncham

    • Nov 16th, 2012

    PPI does not support any join index and hash index