Latest News

Monday, December 11, 2017

Partitioning in Oracle

In Oracle Partition allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. These enhance the query performance. 

In Oracle a Table can be partition by below ways:

  1. Range Partitioning
  2. Hash Partitioning
  3. List Partitioning
  4. Composite Partitioning
  • Google+
  • Pinterest

No comments

Post a Comment