Both horizontal and vertical partitioning can improve performance by reducing bottlenecks that form when too many applications or users attempt to access the same table.
Correct Answer:
Verified
Q103: In vertical partitioning, each partition must have
Q104: Storing derived data improves performance in the
Q105: In the physical design technique known as
Q106: The physical design technique known as "substituting
Q107: In vertical partitioning, the rows of a
Q109: The clustering files technique can result in
Q110: The more volatile the data in a
Q111: Creating views actually changes the logical database
Q112: Data volatility refers to how often stored
Q113: Some physical database design techniques actually change
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents