> > >

DB2 Administration MCQs

Why would you need to execute RUNSTATS regularly when using the SQL compiler?

Executing RUNSTATS updates the optimizer so it can compile the data properly.

Executing RUNSTATS optimizes the compiler so the updater can encode SQL statements sequentially.

Executing RUNSTATS optimizes the data in the right order so the compiler can send it to the optimizer.

Executing RUNSTATS provides the most current data which is used by the optimizer to create an effective access plan.

Answer

Correct Answer: Executing RUNSTATS provides the most current data which is used by the optimizer to create an effective access plan.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it