What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
what is the role of the cursor in db2?
What is a collection in db2?
What is the cascade rule and how does it relate to deletions made with a subselect?
what are the bind parameters?
Is schema the same as database?
Normalization in DB2 – first normal form, second normal form
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is the cobol picture clause of the db2 data types date, time, timestamp?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How can you classify the locks in db2?
What is temporal table in db2?
How and when does the db2 enforces the unique key?