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.