Advantages and disadvantages of table partitioning
What is table partitioning and what are its advantages and disadvantages? Also, what is bulk collection? What are hints?
What is table partitioning and what are its advantages and disadvantages? Also, what is bulk collection? What are...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
hints?
Oracle partitioning is used as a divide-and-conquer approach to make it easier to maintain very large objects (tables and indexes) and to speed up certain types of SQL queries. See my notes here.
The "bulk collect" feature of the PL/SQL language works like the "forall" operator to quickly read many Oracle rows into PL/SQL storage. Find details here and here.
A "hint" is an optimizer directive that is used to override the way that the cost-based optimizer generates an SQL execution plan. See here and here for details.