Database - Distributed Databases - Discussion
Discussion Forum : Distributed Databases - General Questions (Q.No. 6)
6.
Some of the columns of a relation are at different sites is which of the following?
Discussion:
3 comments Page 1 of 1.
Rutuja said:
1 decade ago
What is vertical & horizontal Partitioning ?
Jagdeep Mankotia said:
1 decade ago
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.
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.
Jagdeep Mankotia said:
1 decade ago
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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers