Interested to Buy Any Domain ? << Click Here >> for more details...
What is EXPLAIN?
- 1 Answers
- 6185 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 |
On which levels locks can be applied?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is SPUFI?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
Explain various types of locks in db2?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What are leaf pages?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
Update command
COBOL 
