In this chapter, we will learn techniques that will help in writing statements/SQL queries efficiently. Increasing the efficiency of DDL/DML/DCL statements/SQL queries will reduce the CPU/IO and runtime of a query.
The following topics will be covered:
- Writing queries
- Querying efficiently
- Explain before executing queries
- Decoding explain
- Resolving skewing data
- Resolving skew in databases
- Solving insert performance
- Solving delete performance
- Improving update performance
- Performing merge into
