What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is lock escalation in db2?

0 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

What is host variable?

0 Answers  

---

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

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?

1 Answers  

---

Are views updateable?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---