Suppose I have a program which uses a dynamic SQ

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? ––

Probably RUN STATS is not done and the program is using a wrong index due to incorrect stats.
Probably RUNSTATS is done and optimizer has chosen a wrong access path based on the latest statistics.

(Continued on next question...)

Other Job Interview Questions

• What is 'LIKE' used for in WHERE clause? What are the wildcard characters? –
• Can you use MAX on a CHAR column?
• Where do you specify them ?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What are the advantages of using a PACKAGE?
• How to read last record in vsam file.,I don't know how many records are there?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• What is sqlcode -811?
• What is a synonym? How is it used?
• What is IMAGECOPY ? –
• More...