Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the maximum No of rows per page?
What is query_cache_limit?
How would the varchar column remarks defined?
What is runstats db2?
How do I connect my db2 database to ibm?
is it compulsory commitment control in journal?
What is precompiler in db2?
What is a storage group (stogroup)?
What is null indicator in cobol db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the role of schema in the db2 database?
How can we read records for specific member in CL? AND rpg?
What does db2 mean?
How can we retrieve the total number of records in RPG & CLLE?
