PrepAway - Latest Free Exam Questions & Answers

What are the correct steps to capture EXPLAIN information for column-organized tables?

What are the correct steps to capture EXPLAIN information for column-organized tables?

PrepAway - Latest Free Exam Questions & Answers

A.
1. Issue the query against column-organized tables
2. Execute the db2exfmt command

B.
1. Execute the command CURRENT EXPLAIN MODE YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command

C.
1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command

D.
1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Execute the command CURRENT EXPLAIN MODE YES
3. Issue the query against column-organized tables
4. Execute the db2exfmt command


Leave a Reply