Chapter 25, Problem 10E

Program Plan Intro

  Database tuning:

• Database tuning describes a group of activities that is used to optimize the performance of a database.
• Database tuning helps to analyze all the workloads that executes against a database.
• Database tuning helps to improve the performance of a query.
• It also improves the response time of a transaction or a transaction throughput.

Explanation of Solution

Examples on how tuning can be done

• The first example for tuning the schema and relational schema is to consider a course relation in a university database.
• This relation can be split into two relations.
• Another example for tuning the schema and relational schema is to consider a case where natural join of two relations account and deposit is required in a bank database.
• An example for tuning the buffer manager and transaction manager includes queries that computes tax deducted from account relation are best run at night.
• At this time no update to a customer’s account will be allowed...