What is EXPLAIN?

Question

What is EXPLAIN?

satish yedida · Answer

Addition to Varun:and  Explain utilityand usingand several and 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 · Answer

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

interview

What is EXPLAIN?

Varun Agrawal

Can you answer this question?

2 Answers

Liked By