What is db2 and what is the use of db2 optimizer?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is concurrency?

0 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


What is db2 bind?

0 Answers  


What is the clustering index in the db2 database?

0 Answers  


What is db2 stogroup?

0 Answers  


if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,


How can you get the number of rows impacted by the last executed query?

1 Answers  


PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,


What is subquery ?

6 Answers  


B37 abend during spufi?

0 Answers   IBM,


What do you need to do before you do EXPLAIN?

1 Answers  


Name the various locking levels available?

0 Answers  


Categories