An explain plan is a report that shows how the database engine will execute a given SQL query. It provides information such as the execution order, the access methods, the join methods ...