|
|
|
Support for partition objects is provided in CA ERwin Data Modeler for SQL Server 2005 and 2008.
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.
Define a partition for a table using the Partitions tab.
Define a partition for a table index using the Partitions tab.
Define a partition for a view index using the Partitions tab.
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 © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |