Oracle
1Z0-882 · Question #63
What are two ways in which normalizing your tables helps improve performance In MySQL?
The correct answer is A. Smaller table sizes and row lengths improve sorting operations. C. Fewer nullable column improve index usage. See the full explanation below for the reasoning.
Question
What are two ways in which normalizing your tables helps improve performance In MySQL?
Options
- ASmaller table sizes and row lengths improve sorting operations.
- BSeparate tables allow indexing more columns.
- CFewer nullable column improve index usage.
- DNormalizing Improves the performance of innodb_file_per _table.
How the community answered
(63 responses)- A78% (49)
- B13% (8)
- D10% (6)
Community Discussion
No community discussion yet for this question.