Interested to Buy Any Domain ? << Click Here >> for more details...
What is EXPLAIN?
- 1 Answers
- 6238 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 |
The only place of VSAM KSDS in DB2 is?
What is bufferpool in db2?
what is sql abend code -801,-802?
How will you return the number of records in table?
Name the various locking levels available?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
How to check table size in db2 sap?
What is a db2 collection?
Explain about dbrm.
what is the use of commit ? and what is the syntax?
COBOL 
