How do I optimize a query in db2?


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

Post New Answer

More DB2 Interview Questions

What is clone table?

0 Answers  


What are the contents of a dclmgen?

0 Answers  


Write a query to retrive partial string.

2 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,






How Plan is created while executing the query using SPUFI?

3 Answers  


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


What is with ur in db2?

0 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


What is meant by dclgen?

0 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


Categories