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 |
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Highlight all the advantages that are attached to a package.
What is meant by a unit of recovery?
what are the SQL codes u freequently got?
What is a correlated sub query?
How do I optimize a query in db2?
What is a root page?
Explain the contention situations caused by locks?
wt is view ? wht r the restrictions for view ?
What is index cardinality?
How do you run JCL in cobol program
what needs to be done if a table is in copy pending / check pending status?