What is bind plan?

0 Answers  

---

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  

---

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 do you need to do before you do EXPLAIN ?

1 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

---

What is the use of db2 optimizer?

0 Answers  

---

difference between group clause and order clause

1 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What are packages in db2?

0 Answers  

---

What is pagespace?

1 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---