Q
Problem solve Get help with specific problems with your technologies, process and projects.

Determining if a table should be partitioned

What should a DBA look at, besides size, to determine if a table should be partitioned?
Besides overall size, one should look at the data access patterns. It is helpful if the table is partitioned on how it is accessed. For instance, if I have a table for INVOICES and the invoices are typically searched by DATE, then I would partition on the invoice date column. Each partition might hold a year's worth, or a quarter's worth of data. By partitioning with the data access in mind, one can enjoy the benefits of "partition pruning." This is eliminating those partitions that will not participate in the query. So when I query for all invoices generated last year, only the partition(s) that hold that data will be used. Partitions holding previous year's data will be ignored.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close