| |||||
|
What is EXPLAIN? More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) What is EXPLAIN? 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). The results of EPLAIN is stored in U.PLAN_TABLE where U is the authorization id of the user. (Continued on next question...)
Other Job Interview Questions
|
||||