Interested to Buy Any Domain ? << Click Here >> for more details...
what is rebinding ?
- 1 Answers
- 5996 Views
- IBM, I also Faced
- E-Mail Answers
Answer / sravani
when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)
| Is This Answer Correct ? | 4 Yes | 0 No |
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What are the benefits of using the db2 database?
What is the use of dclgen in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are the 4 environments which can access DB2 ?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What does DML stand for and what are some examples of it?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
pls explain the precompilation process of cobol-db2 pgm
Give some example of statistics collected during RUNSTATS?
What is DCLGEN ?
COBOL 
