Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Partitioning > Partitioning Types

Partitioning Types

Partitioning provides benefits by dividing up a larger table into smaller portions, based on the value of the partition key. A table or index can only be partitioned once at the top level, of course, since partitioning dictates the logical storage of the object, but the partitioning scheme used must correspond with the way that a query will be requesting data in order to provide performance benefits. Because of this, Oracle has continually expanded the ways that you can partition tables since the introduction of this feature with Oracle 8.

Image

FIGURE 2-8. Index and table partitioning

Oracle Database 11g Release 2, the current release of the database at the time of this writing, supports the following types of partitioning:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint