Explore BrainMass

Explore BrainMass

    Database, table and query design affect database performance

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1) Discuss how database design, table design, and query design affect database performance. Pick one of these design issues, explain how it impacts performance, and discuss what could have been done to avoid the problem in the first place.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:28 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/database-table-query-design-affect-database-performance-233173

    Solution Preview

    Database Performance
    Discusses how database design, table design, and query design affect database performance. Pick one of these design issues, explain how it impacts performance, and discuss what could have been done to avoid the problem in the first place.
    Database performance depends on many factors.
    1. Database Design:
    Design database properly, i.e. a normalized database design is usually a good starting point. This depends on the purpose database being used. If this is used for OLTP purpose database has to follow normalized design.
    You need follow database design to de-normalize for the purpose of Data ware ...

    Solution Summary

    The expert discusses how database design, table design and query design affects database performances. How it impacts performance is explained.

    $2.19

    ADVERTISEMENT