Why Use Table Partitioning
Table partitioning can help DBAs key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. New table partitioning methods found in Oracle Database 11g can be implemented to help to achieve some of these goals.
Database administrators tend to focus on There are several key areas when looking for opportunities to improve performance in their databases. These include memory utilization, SQL performance, space and storage requirements, network bottlenecks, and i/o performance.
Considered part of the very large database support features, table partitioning is an option available to database administrators that can help at least two of these key performance areas: i/o and SQL performance. By taking key large "hot" tables (and indexes) and partitioning them so that they are stored in different tablespaces, a dba may see performance gains in several areas.
Read the full article at Database Journal: Oracle Database 11g New Features for Table Partitioning to learn why to use table partitiioning.
Back to DBAsupport.com
