Which of the options below can you use to do the same?

You have an employee table and you want to view the explain results in a tabular form for the below query

SELECT * FROM EMPLOYEE;

Which of the options below can you use to do the same?
A . SELECT * FROM TABLE(
EXPLAIN_JSON(
SYSTEM$EXPLAIN_PLAN_JSON(
‘SELECT * FROM EMPLOYEES’)
)
);
B. EXPLAIN USING TABULAR SELECT * FROM EMPLOYEES;
C. EXPLAIN AND CONVERT TO TABULAR SELECT * FROM EMPLOYEES;

View Answer

Answer: A, B

Explanation

https://docs.snowflake.com/en/sql-reference/functions/explain_json.html#explain-json

EXPLAIN_JSON

This function converts an EXPLAIN plan from JSON to a table. The output is the same as the output of the command EXPLAIN USING TABULAR <statement>.

See also:

SYSTEM$EXPLAIN_PLAN_JSON , SYSTEM$EXPLAIN_JSON_TO_TEXT