Implementing a database storage scheme based on multiple tablespaces or file groups provides various benefits. For example, you can optimize input and output operations, while backup and maintenance operations are easier to manage.
The CA DataMinder database schema also provides support for Oracle database partitioning based on event time stamps. Partitioning benefits include faster queries, improved database manageability and availability. For example, this allows DBAs to quickly purge partitions containing data that no longer needs to be retained without incurring the cost of row-level operations.
|
Copyright © 2014 CA.
All rights reserved.
|
|