what is rebinding ?
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 |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what's the error code for Unique Index Violation?
Give some example of statistics collected during RUNSTATS?
How to know the primary key of a table without defining the primary key in the table?
what types of copies can be made with the COPY Utility ?
List down the types of triggers in the db2 database?
How and when does the db2 enforces the unique key?
What is host variable?
How does cobol compile db2 program?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is data manager?