> > >

DB2 Administration MCQs

Why would you want to specify an optimization class when compiling an SQL query?

So the organizer chooses the fastest access plan for that query.

So the optimizer chooses the most efficient access plan for that query.

So the optimizer chooses the slowest access plan for that query.

So that Optimus Prime chooses the slowest access plan for that query.

Answer

Correct Answer: So the optimizer chooses the most efficient access plan for that query.

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