Explain Plan

From Wikipedia, the free encyclopedia

An explain plan is a feature provided by the majority of relational databases. When the database engine is provided with an SQL statement it computes the access path used to execute the query. This is used for troubleshooting performance issues in a database.