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.

results matching ""

    No results matching ""