SQL code explainability and optimization using Amazon Q Developer

Amazon Q Developer offers a simple interface to achieve code explainability and optimization. For more details on the explainability and optimization topic, refer to Chapter 12.

To illustrate, I am going to use the previously auto-generated code during the store procedure creation task. As shown in the following screenshot, highlight the code section generated during the store procedure, right-click to open the pop-up menu, select Amazon Q, and then choose Explain for code explainability or Optimize for optimization recommendations.

Figure 7.15 –SQL code explainability and optimization

This will pop up Amazon Q Developer’s chat-style interface and use the full code for analysis.

For explainability, Amazon Q Developer provides details for almost every line of code and at the end provides a summary, such as the following: “When the join_emp_dept stored procedure...