what are the importance of partitioning in DBMS ?

devquora

Posted On: Feb 22, 2018

Database partitioning is the process of splitting large tables into smaller database entities. Following are the benefits of partitioning-

When rows are in one partition, query performance in such situations is improved.
It also helps to access large parts of single partition.
Data which are rarely used can be stored in slower and cheaper storage medium.

DBMS (Database Management System) is a computer software application that allows users and other applications to view,..

There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..

Database language is used to create and store data in computer system. DBMS itself is one of the features of database l..

Related Questions