Problem solve

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?

Don Burleson

Published: 14 Nov 2005

What is table partitioning and what are its advantages and disadvantages? Also, what is bulk collection? What are...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

PL/SQL (procedural language extension to Structured Query Language)

What's the difference between DDL and DML?

Apache Sqoop a crucial link for big data analytics in the cloud

SQL Server 2014 columnstore index: the good, the bad and the clustered

Please create a username to comment.

MongoDB Atlas now enables multi-cloud database clusters

How AI data privacy can help your enterprise

The new normal for enterprise data governance

Logi Analytics keeps focus on embedded app development

Data literacy skills key to cost savings, revenue growth

Yellowfin 9.3 features embedded app development upgrades

Decide on SAP S/4HANA Cloud: Single-tenant vs. multi-tenant edition

How 2 S/4HANA projects wrapped up remotely due to COVID-19

Wookey returns to SAP to head Intelligent Spend unit

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

3 ways to implement AI in software development

5 helpful tips to reduce webpage load time, improve performance

Is Apache Tomcat the right Java application server for you?

IBM cloud revenues climb as hardware continues to decline

Figure out the differences of asset management vs. CMDB

IBM partners with HBCUs to promote quantum computing

Choosing the right collaboration suite for business

Acquia Drupal, Marketing Cloud get feature boosts

How automated content tagging improves findability

Tensions over politics at work have HR on guard

Top 9 tech skills HR professionals need for success

As contingent employee hiring rises, HR gives it focus

Dig Deeper on Oracle database design and architecture

PL/SQL (procedural language extension to Structured Query Language)

What's the difference between DDL and DML?

Apache Sqoop a crucial link for big data analytics in the cloud

SQL Server 2014 columnstore index: the good, the bad and the clustered

Related Q&A from Don Burleson

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.