IBM
P2090-050 · Question #11
Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?
The correct answer is A. Use explain. See the full explanation below for the reasoning.
Question
Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?
Options
- AUse explain.
- BUse statistics.
- CUse pg.log file.
- DSet show_plan = true;
How the community answered
(57 responses)- A79% (45)
- B2% (1)
- C12% (7)
- D7% (4)
Community Discussion
No community discussion yet for this question.