IBM
C2090-558 · Question #58
Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)
The correct answer is B. CREATE PROCEDURE E. UPDATE STATISTICS FOR PROCEDURE. See the full explanation below for the reasoning.
Question
Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)
Options
- ACALL PROCEDURE
- BCREATE PROCEDURE
- COPTIMIZE PROCEDURE
- DEXECUTE PROCEDURE
- EUPDATE STATISTICS FOR PROCEDURE
How the community answered
(32 responses)- A3% (1)
- B75% (24)
- C6% (2)
- D16% (5)
Community Discussion
No community discussion yet for this question.