Discuss about db2 bind?



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

Post New Answer

More DB2 Interview Questions

What is an inner join, and an outer join ?

1 Answers   CTA,


what is diffrence b/w file-aid tool and file-aid utility???

2 Answers  


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


How to restart a DB2 program?

1 Answers   Cognizant,


What is database alias db2?

1 Answers  


How do I connect my db2 database to ibm?

1 Answers  


What is a buffer in memory?

1 Answers  


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..

5 Answers   CTS,


Is db2 a programming language?

1 Answers  


can we view the access paths created by dbrm ? how ? thx

3 Answers   IBM,


what is the process of precompiler?

2 Answers  


Which is faster delete or truncate?

1 Answers  


Categories