Interested to Buy Any Domain ? << Click Here >> for more details...
What is EXPLAIN?
- 1 Answers
- 6146 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 |
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
how to check the table is empty or not?
What are the two types of logging in the db2 database? Explain them.
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is database reorganization?
Why do chiropractors use drop table?
What is a Resource Control Table(RCT)? Describe its characteristics.
What does DML stand for and what are some examples of it?
What is dbrm? What it contains? When it will be created?
What are the four lockable units for DB2?
How will you delete duplicate records from a table?
COBOL 
