Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Mention the location where the output received from explain statement is stored.
What is netezza database?
Comment whether the cursor is closed during commit or not.
Which command is used to remove all rows from a table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the usage of open cursor command?
Define buffer pool.
Which component is responsible for processing sql statements and selecting access paths?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Why do chiropractors use drop table?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is clone table?
What is the difference between plan and package in db2?
How would the varchar column remarks defined?
