Problem solve
Get help with specific problems with your technologies, process and projects.
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.
Step 2 of 2:
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.
Dig Deeper on Oracle database design and architecture
-
![]()
PL/SQL (procedural language extension to Structured Query Language)
By: Lindsay Moore
-
![]()
What's the difference between DDL and DML?
By: Bridget Botelho
-
![]()
Apache Sqoop a crucial link for big data analytics in the cloud
By: Dan Sullivan
-
![]()
SQL Server 2014 columnstore index: the good, the bad and the clustered
By: Robert Sheldon
