the estimated number of rows or bytes processed, the indexes used, the join methods, the predicates, and the hints. Explain plans can help you improve your SQL queries in several ways, such as ...

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 ...