Support for partition objects is provided in erwin® Data Modeler for SQL Server 2008, 2012, 2014, and 2016
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 © 2017 erwin Inc.
All rights reserved.
|
|