Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

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,

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

What information is used as input to the bind process?

2 Answers  

---

What is the difference between base table and view?

7 Answers  

---

---

What is bind plan?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

What is the logical entity between plan and Package?

5 Answers  

---

what is consistency token

3 Answers  

---

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

1 Answers  

---

What is correlated subquery?

1 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---