Improving performance may involve any/all of:

• making applications using the DB run faster
• lowering response time of queries/transactions
• improving overall transaction throughput

• the query optimiser removes choices from DB developers
• by making its own decision on the optimal execution plan