Why Partition

• Makes it possible to store more data in one table more than cab ne held on a single disk or file system.
• Easy to add and drop partitions.
• Improves query performance by retrieving data from specific partitions using a technique called partition pruning

Partitioning applies to all data and indexes of a table, you cannot partition only the data and not the indexes, or vice versa, nor can you partion only a portion of the table.