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
Explain what are the various isolation levels possible?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is null in db2?
Which are the db2 tools to protect integrity of the database?
What is a bind card?
How to check last update on table in db2?
What is a Foreign Key?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What type of database is db2?
How can you classify the locks in db2?
What are union and union all?
What is the difference between bind and rebind in db2?
What is db2 and what is the use of db2 optimizer?
How do I connect my db2 database to ibm?
