Partitioning is the process of creating smaller tables containing a subset of the data with the same format as the original table. Each partitioned table has rows allocated to it based on some characteristic of the data, such as specific key ranges. Partitioning can improve application processing speeds and reduce the potential for conflicts in multi-site update replication.
Specify a function that defines how the rows of a partitioned table or index are spread across a set of partitions based on the values of specific columns, which are referred to as partitioning columns.
Specify a database object (scheme) that maps the partitions of a partition function to a set of filegroups.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |