What is EXPLAIN?

Question

What is EXPLAIN?

satish yedida · Answer

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.

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?

Can you answer this question?

2 Answers