A company is designing a database to store large volumes of transactional data with a focus on read performance. Which database design technique might they consider to optimize data retrieval times?
- Denormalization
- Indexing
- Normalization
- Partitioning
To optimize read performance for large volumes of data, denormalization is a technique. It involves reducing the level of normalization to decrease the number of joins and improve query performance.
Loading...
Related Quiz
- How can real-time monitoring and logging impact the user experience of a software application?
- How does requirement validation contribute to the overall success of a software development project?
- In a CI/CD pipeline, the _______ stage is responsible for ensuring that the code changes do not break the existing functionality.
- What is the main objective of performance testing in software development?
- Which aspect of SDLC can be considered as a limitation when changes are introduced late in the development process?