Partitioning in Oracle

Writen by Devil 12:29 AM - 0 Comments

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

• Facebook
• Tweeter
• Google+
• Whatsapp Pinterest