SQLs

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