Which tool should the developer use to troubleshoot query performance?

A developer must troubleshoot to pinpoint the causes of performance issues when a custom page loads in their org.

Which tool should the developer use to troubleshoot query performance?
A . Setup Menu
B . Developer Console
C . Visual Studio Code IDE
D . AppExchange

View Answer

Answer: B

Explanation:

To troubleshoot query performance issues:

Option B: Developer Console

The Developer Console provides tools like the Query Plan to analyze SOQL queries for performance.

Using Query Plan Tool:

Open Developer Console.

Go to the Query Editor.

Enter your SOQL query.

Click on "Explain" to see the query plan.

Reference: "Use the Query Plan tool in the Developer Console to optimize and troubleshoot SOQL queries."

― Salesforce Developer Guide: Query Plan Tool Why Other Options Are Incorrect:

Option A: Setup Menu does not provide tools for query performance.

Option C: Visual Studio Code IDE requires extensions and is less direct for query performance.

Option D: AppExchange is for finding apps, not for troubleshooting performance.