What are the uses of db2 optimizer?

0 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 load and unload in db2

1 Answers   IBM,

---

How do you check for a null value in a db2 column?

2 Answers  

---

When do you specify the isolation level?

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What are bind parameters in db2?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What is correlation names?

1 Answers  

---

What does the REORG Utility do?

2 Answers  

---

How to create a table using embedded sql?

1 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---