The performance of static SQL is better than dynamic SQL, because for static SQL the binding is done only once and the program can be executed many times
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Dynamic SQL statements are embedded in programs and bound before they are executed.
- Native dynamic sql works faster than dbms_sql
- The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.
- In Dynamic SQL ,The COMMIT or ROLLBACK statement destroys the prepared statement and the statement need to ...
- What can be used to optimize the performance of simple SQL?
- What can be used to optimize the performance of simple SQL?
- The source form of static SQL statements is :
- Which of the following prevents SQL statements from being repeatedly parsed thus improving performance duri...