Multiple choice technology performance

Hard parse is expensive than Soft Parse

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hard parse is more expensive than soft parse because hard parse involves optimization, query plan generation, and row source generation. Soft parse only checks the shared pool for an existing execution plan and skips these costly steps when a plan is found.

Keep practicing — related questions