Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 16. High Performance SQL Tuning > Use Bind Variables
Use Bind Variables
The Oracle database software caches SQL statements issued; the cached statement is then reused if an identical statement is issued later. When a statement is reused the execution time is reduced. There’s a catch, however: the SQL statement must be absolutely identical in order for the cached statement to be reused. This means that
All characters must be the same.
All letters must be of the same case.
The use of spaces in the statement must be the same.
