What are some characteristics of columns that benefit from indexes?

1 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What is the difference between cursor and select statement?

0 Answers  

---

What is correlated subquery?

1 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is a precompiler?

2 Answers  

---

What is multi row fetch in db2?

0 Answers  

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---