Answer / s

The optimizer will determine all the different access paths
for the query and does a cost-based analysis and chooses
the the least expensive path.

Answer / srinivas yadav

OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.

What is the maximum size of a char data type in db2?

0 Answers  

---

What is the use of reorg in db2?

0 Answers  

---

What is a plan and package in db2?

0 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

When do you specify the isolation level?

0 Answers  

---

How can deadlocks be resolved?

0 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What is check constraint. Explain with example.

0 Answers  

---

Is db2 relational database?

0 Answers  

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---