Correct Answer: Runstats on table john.table1 and indexes all
Explanation:
Note: This question has more than 1 correct answers
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
More DB2 Administration MCQ Questions
The various locking levels available are:
What happens during a DB2 Checkpoint?
Can you update a view which is based on more than one table?
What is dynamic SQL?
What is a DB2 access path?
In a UNIX-based environment, where would the database manager configuration file be found?
Why would you need to execute RUNSTATS regularly when using the SQL compiler?
I have 5 SQL Select statements connected by a Union/Union All. How many times should I have to specificy union to eliminate duplicate rows?
What is the benefit of prefetching data?
What is a DB2 IMAGECOPY