Discussion
Which technique improves read performance in databases at the cost of redundancy ?
Answer: C
The technique is Denormalization.
Denormalization deliberately adds redundant data, for example copying a customer's name into an orders table or storing precomputed totals, so that common queries need fewer joins. Reads become faster at the cost of duplicated data and more work to keep the copies consistent on updates.
Normalization does the opposite, removing redundancy. Indexing speeds reads with extra index structures rather than duplicated table data, and partitioning splits a table into pieces; neither is defined by trading redundancy for read speed.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development