How to do it...

1. Identify the query for which you want to check the explain.
2. It is recommended to check the explain of all the queries before executing, as query plans get changed if table demographics are changed.
3. Hit F6 by selecting the query to get the explain, or write the EXPLAIN keyword before the query and press F5:

Explain
Insert  Into  test01.webclicks 
select * From    au.az_clicks;

1. The explain plan will be generated in the result set window.