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 the soft code for deadlock ?

2 Answers   Logica CMG,


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


What is db2 purescale?

0 Answers  


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  


What is bind package and plan in db2?

0 Answers  


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

2 Answers   Tech Mahindra, Wipro,


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


What is the purpose of rollback and commit?

0 Answers  


Mention data types used in db2 ?

0 Answers  


How would you find out the total number of rows in a db2 table?

0 Answers  


when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,


Categories