Multiple choice technology databases

What is the utility used to check the performance of the DB2 SQL query

  1. Explain

  2. Xpeditor

  3. Alchemist

  4. Abendaid
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The EXPLAIN statement or utility is used to capture and analyze the access paths chosen by the DB2 optimizer for executing SQL queries, which is vital for performance tuning. Other options like Xpediter, Alchemist, and Abend-AID are debugging, configuration management, or dump analysis tools instead.

Keep practicing — related questions