Apex Code Development You need to sign in to do that
Don't have an account?
Ken Koellner @ Engageware I noticed Apex Debug Logs do not explain query plans for Dynamic SOQL, only static SOQL
This isn't so much a question as an observation, unless someone knows a work around.
It's nice the Apex debug logs now show an explanation of the query plan for SOQL as shown below --
10:00:09.343 (6541134992)|SOQL_EXECUTE_EXPLAIN|[150]|Index on Event : [Meeting__c], cardinality: 1, sobjectCardinality: 12760, relativeCost 0.001
However, it only does that for static SOQL. For dynamic SOQL, it doesn't show a query plan--
10:00:09.343 (6677301225)|SOQL_EXECUTE_EXPLAIN|[312]|No explain plan is available
There are some cases where I wanted to check that a generated query was efficient so I had to extract the SOQL generated, then run it manually in Dev Console to check it.
It would be nice if debug also showed query plans for Dynamic SOQL.
As you are already aware, the query plan is something not available for dynamic SOQL.
Found a similar ask from the past: https://salesforce.stackexchange.com/questions/332530/is-that-possible-to-use-query-plan-for-dynamic-soql-queries
Recommend logging an Idea on IdeaExchangePortal as a feature request.
If this information helps, please mark the answer as best. Thank you
I really think there should be a seperate Idea Exchange just for development and technical features unrelated to business funcitonality.