Topic
  • 1 reply
  • Latest Post - ‏2012-11-19T20:45:07Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic Bind and Rebind

‏2012-11-18T16:35:30Z |
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
    SystemAdmin
    1632 Posts

    Re: Bind and Rebind

    ‏2012-11-19T20:45:07Z  
    Bind 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.