Discuss about db2 bind?
Answer / Tauseef Rafat
DB2 Bind is a process of preparing and optimizing SQL statements for execution. This process involves binding the statement to the appropriate database objects, optimizing the query plan, and reserving resources like memory and I/O buffers. The bound statement can then be executed multiple times without re-optimization.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an inner join, and an outer join ?
what is diffrence b/w file-aid tool and file-aid utility???
how to resolve -805 . how to see dbrm and package not found
How to restart a DB2 program?
What is database alias db2?
How do I connect my db2 database to ibm?
What is a buffer in memory?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
Is db2 a programming language?
can we view the access paths created by dbrm ? how ? thx
what is the process of precompiler?
Which is faster delete or truncate?