What is the difference between soft parsing and hard parsing of SQL?

Question

Accepted Answer

Soft parsing is reusing the existing execution plan while hard parsing is generating a new execution plan.

Soft parsing is faster as it avoids the overhead of generating a new execution plan.
Hard parsing is slower as it involves generating a new execution plan.
Soft parsing occurs when the SQL statement is already in the shared pool.
Hard parsing occurs when the SQL statement is not in the shared pool or needs a new execution plan.
Soft parsing saves CPU and memory resources.
Hard parsing consumes CPU and memory resources.
Soft parsing is more efficient for frequently executed SQL statements.
Hard parsing is more efficient for rarely executed or complex SQL statements.

Accepted Answer

Hard parsing executes the statistics utilizes index form and soft parsing it is already executed plan

Accepted Answer

when we are parse, the database check shared pool to see if an statement is already existing or not if statement is existing then reteive form shared pool called soft parsing.

if oracle database can not reuse existing code then it build a new executable version of the apllication is called as hard parsing.

What is the difference between soft parsing and hard parsing of SQL?

Cognizant Plsql Developer interview questions & answers

Popular interview questions of Plsql Developer