Partitioning an important part of database optimization

Explain how partitioning is an important part of database optimization?

- Partitioning distributes database tables over different database which may reside on a different server.

- Vertical portioning helps to fit more rows on a database page to improve data access performance.

- Partitioning helps to do multiple tasks simultaneously.

- It increases performance.

- It helps to manage data.

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

Following are the benefits of Partitioning:

1. Improving query performance dramatically in situations when most of the heavily accessed rows of the table are in a single partition.

2. To access large percentage of a single partition of the queries or updates are accessed by the queries, the performance can be improved by taking advantage of scanning the partition sequentially.

3. Data that is seldom used could be migrated for cheaper and slower storage media.
SSIS Interview Questions and Answers - Freshers & Experienced
SSIS interview questions and answers for freshers and experienced - Difference between control flow and data flow?, If you want to send some data from Access database to SQL server database. What are different component of SSIS will you use?, Explain why variables called the most powerful component of SSIS?
Post your comment