Question 2

Question 1

What is Database performance tuning?

Answer 1

A set of activities and procedures designed to reduce the response time of a database system.

Question 2

What is SQL performance tuning?

Answer 2

On the client side – that will generate an SQL query to return the correct answer in the least amount of time, using the minimum amount of resources at the server end.

Question 3

What is DBMS performance tuning?

Answer 3

On the server side – that will properly configure the DBMS environment to respond to clients’ requests in the fastest way possible, while making optimum use of existing resources.

Question 4

What are the three phases a DBMS uses to process SQL queries?

Answer 4

1. Parsing - The DBMS parses the SQL query and chooses the most efficient access/execution plan.
2. Execution - The DBMS executes the SQL query using the chosen execution plan.
3. Fetching - The DBMS fetches the data and sends the result set back to the client.