What is EXPLAIN?
- 1 Answers
- 4939 Views
- I also Faced
- E-Mail Answers
Answer / sadiq afroze
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 EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user
| Is This Answer Correct ? | 5 Yes | 0 No |
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is the difference between db2 and oracle?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
what is the responsibility of the construction superintendent
How many types of page locks can be held in db2?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What Utility is used to migrate DB2 from one release to the next?
What is the difference between cursor and select statement?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
Which catalog tables contain authorization information?
Why cursor is used in db2?
COBOL 
