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 ).
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
Addition 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.