Which of the following must happen before the Big SQL EXPLAIN command can execute?

Posted by: Pdfprep Category: C2090-101 Tags: , ,

Which of the following must happen before the Big SQL EXPLAIN command can execute?
A . Run the ANALYZE command
B . Set the COMPATIBILITY_MODE global variable
C . Execute the SET HADOOP PROPERTY command
D . Call the SYSPRO
E . SYSINSTALLOBJECTS procedure

Answer: D

Explanation:

Reference: https://developer.ibm.com/hadoop/docs/biginsights-ibm-open-platform/getting-started/tutorials/big-sql-hadoop-tutorial/getting-started-with-big-sql-4-0-lab-6-understanding-and-influencing-data-plans/

Leave a Reply

Your email address will not be published.