0
What is difference between Horizontal and Vertical Partitioning?
Wiki User
∙ 14y ago
Horizontal partitioning:
Horizontal partitioning is partitioning the table into no.of smaller tables on the basis of rows.
Eg:
In an employee table, employees with salary less than $10,000 will be partitioned into different table.
Vertical Partitioning:
Vertical parttioning is dividing the table based on the different columns.
Eg:
In the same employee table, retrieving oly the name and contact number of all the employees into a different table.
Wiki User
∙ 14y ago
Wiki User
∙ 8y agoIn DBMS the data can be partitioned either horizontally or vertically. In vertical partitioning the table is divided on the basis of columns . In horizontal partitioning the table is divided on the basis of rows .
Add your answer:
Earn +20 pts
Importance of line graph?
The major importance of a line graph is that it allows a person to visually see the relationship between two major variables. A line graph contains a vertical axis and a horizontal axis.
What is the difference between a pie chart and a bar graph?
A pie chart is round, and a bar graph is square with the bars running either horizontal or verticle.
What can you say about the correlation coefficient and the correlation description when the points lie exactly on vertical or horizontal line?
Let me rephrase: Case 1: You have x and y variables, but the values for x is a constant (vertical line) Case 1: You have x and y variables, but the values for y is a constant (horizontal line) Result is that you have zero covariance, so a correlation coefficient can not be calculated because that would cause a division by zero. If one of your x value (Case 1) or y value (case 2) is not exactly the same as the others, then a correlation coefficient can be calculated, but does it mean anything? The correlation coefficient indicates a linear relationship between two random variables, not between a constant and a random variable.
What is the difference between statistics and parameter?
What is the difference between statistics and parameter
What is the difference between OLAP and data mining?
difference between Data Mining and OLAP
What is the difference between a vertical and a horizontal timelines?
what is the difference between vertical and horizontal timeline
What is the difference between vertical and horizontal systems packages?
explain the difference berween vertical and horizontal system packages?
What is the difference between horizontal growth and vertical growth?
horizontal grows wide, and vertical grows up
What is the difference between vertical and horizontal lines?
vertical lines run from top to bottom, horizontal lines run from left to right the difference between the two is 90 degrees if you place vertical lines next to horizontal lines.
What is the difference between horizontal and vertical motion?
Our jumping is a vertical motion, while walking is a horizontal motion. Exercises are done by both horizontal and vertical motion.
What is the difference between vertical and horizontal alignment?
In TextAlign, the difference between vertical and horizontal alignment is which way you align something. Horizontal alignment is set by aligning to the center, right, or left and vertical alignment is set by aligning to the top, bottom, or middle of a cell.
What is the difference between horizontal shaft and vertical?
XXXXXXXXX=Horizontal X X X X X X X=Vertical.
What is the difference between rows and columns?
Rows are horizontal and columns are vertical.
What is the difference between horizontal forms and vertical forms of balance sheet?
vertical is strait up and down and horizontal is across (strait across)
What is the difference between horizontal and vertical?
Vertical is up and down and horizontal is side to side. Think of the horizon, it is a line and horizontal has the same root. In fact, one definition of horizontal is parallel to or in the plane of the horizon.
What is the Difference between horizontal and vertical engine?
Vertical engines produce more power than horizontal engines and horizontal engine has less power than vertical engines and horizontal engines are especially designed for better mileage Not sure about mileage but the big difference is vertical shaft goes like this | and the horizontal shaft goes like this ---- . > Lower centre of gravity.
Whats the difference between vertical and horizontal writing?
vertical is top to bottom(parallel to Y axis). horizontal is left to right(parallel to X axis).
