EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).
Liked By
Write Answer
What is EXPLAIN?
Join MindStick Community
You have need login or register for voting of answers or question.
satish yedida
27-Dec-2012Addition to Varun: Explain utility using several tables for storing accesspath information. The main tables are :
1. Plan table : It stores the access path information.
2. Dsn statement table : It stores cost estimation information.
3. Dsn function table : It stores user defined function if explain using such functions.
Varun Agrawal
28-Mar-2011