Partitioning an important part of database optimization

<<Previous   Next>>

Database - partitioning an important part of database optimization - Jan 07, 2010, 13:55 pm by Vidya Sagar

Explain how is partitioning an important part of database optimization. 

Database partitioning is the process of splitting one large table of a database logically into smaller physical entities. Partition benefits in

- Improving query performance dramatically in situations when most of the heavily accessed rows of the table are in a single partition. 
- To access large percentage of a single partition the queries or updates are accessed by queries, the performance can be improved by taking advantage of scanning the partition sequentially.
- Data that is seldom used could be migrated for cheaper and slower storage media. 

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring