EXPLAIN and Procedures - Teradata Vantage

You cannot EXPLAIN procedures.

For example, if you compile the procedure update_orders and perform the following EXPLAIN, an error occurs because update_orders is not a valid SQL statement.

     EXPLAIN update_orders;

Use EXPLAIN while building procedures. You must extract the SQL text from the procedure body and EXPLAIN each statement. This may require modification of the procedure SQL text. For example, you may have to remove an INTO clause or add a USING request modifier to represent procedure variables and parameters.