A data engineer wants to improve the performance of SQL queries in Amazon Athena that run against a sales data table.
The data engineer wants to understand the execution plan of a specific SQL statement. The data engineer also wants to see the computational cost of each operation in a SQL query.
Which statement does the data engineer need to run to meet these requirements?
To understand the execution plan of a specific SQL statement and see the computational cost of each operation in the query, the EXPLAIN ANALYZE statement should be used. This statement provides both the execution plan and the actual computational costs involved in running the query. The correct syntax is 'EXPLAIN ANALYZE SELECT * FROM sales;'. This combines the capabilities of EXPLAIN to show the execution plan with ANALYZE to show the computational costs.
use EXPLAIN ANALIZE https://docs.aws.amazon.com/athena/latest/ug/athena-explain-statement.html
A - Only partially meets the requirements as it does not include computational costs. B - Incorrect syntax and does not meet the requirements. C - Fully meets the requirements by providing both the execution plan and the computational costs. D - Incorrect syntax and does not meet the requirements.
explain analyze + select * from table