Question #76081
What is the main benefit of denormalizing a normalized table?
Less data redundancy
Less space needed
More security
Improved speed of data retrieval
Less data redundancy
Less space needed
More security
Improved speed of data retrieval
Expert's answer
The correct answer is: Improved speed of data retrieval.
Instruction “JOIN” requires quite a lot of time to perform.
Denormalization reduces the number of “JOINs” and improves speed of data
retrieval due to this.
Instruction “JOIN” requires quite a lot of time to perform.
Denormalization reduces the number of “JOINs” and improves speed of data
retrieval due to this.
