This topic has been locked.
1 reply Latest Post - 2012-11-19T20:45:07Z by SystemAdmin
Pinned topic Bind and Rebind
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
What is all about bind and Rebind in DB2 what internally happened during this process.
Updated on 2012-11-19T20:45:07Z at 2012-11-19T20:45:07Z by SystemAdmin
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Bind and Rebind2012-11-19T20:45:07Z in response to SystemAdminBind is the query compilation process, that is done at compilation time (static query) and not at runtime (dynamic query).
This is a big process behind, but globally it does:
- Checks the security to see if the user can execute that query.
- Creates the data access plan (indexes, joins, etc.)
- Stores the access plan in the database.