Use EXPLAIN only with requests that return data. EXPLAIN returns multiple rows of a single column whose data type is VARCHAR(80). EXPLAIN can be performed only with a cursor.
For static execution of EXPLAIN, see Stored Procedures and Tactical Queries, substituting an EXPLAIN-modified SQL request for the query_expression clause shown there.
Do not perform EXPLAIN request modifiers dynamically because the result is unpredictable.