jump to navigation

An Introduction to Oracle Partitioning March 15, 2007

Posted by Muhammad Habib in Oracle General.
trackback

Oracle partitioning makes it easier and faster to manage any amount of data. Just as a bookstore organizes its books on shelves by subject area, partitioning allows you to organize your database to simplify administration and improve performance.

Although your database may have twice as much data next year as it does today, end-users will not tolerate it if their applications are running twice as slow. Partitioning is a feature that allows a database to scale for very large datasets while maintaining consistent performance, without unduly increasing administrative or hardware resources.

Oracle partitioning enables a “divide and conquer” technique for managing the large tables in the database, especially as those tables grow.

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: