Discussion :: Distributed Databases - General Questions (Q.No.6)
Rutuja said: (Jul 9, 2012) | |
What is vertical & horizontal Partitioning ? |
Jagdeep Mankotia said: (Apr 26, 2013) | |
Partitioning a database improves performance and simplifies maintenance. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. Maintenance tasks, such as rebuilding indexes or backing up a table, can run more quickly. |
Jagdeep Mankotia said: (Apr 26, 2013) | |
Partitioning a database improves performance and simplifies maintenance. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. Maintenance tasks, such as rebuilding indexes or backing up a table, can run more quickly. Horizontal partitioning divides a table into multiple tables. Each table then contains the same number of columns, but fewer rows. Vertical partitioning divides a table into multiple tables that contain fewer columns. |
Post your comments here:
Name *:
Email : (optional)
» Your comments will be displayed only after manual approval.