The EXPLAIN statement provides debugging and analysis details for a DELETE, INSERT, SELECT or UPDATE statement.

Synopsis

EXPLAIN ( explain_option_name , ) select_stmt create_stmt drop_stmt alter_table_stmt insert_stmt update_stmt delete_stmt show_stmt help_stmt split_stmt

Required Privileges

The user requires the appropriate privileges for the statement being explained.

Parameters

Parameter Description
   


Yes No