What happens to the PLAN if index used by it is dropped?
Answer / s
The plan is invalidated and an automatic rebind is
attempted next time is the plan is executed.
Is This Answer Correct ? | 4 Yes | 0 No |
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
what is sql abend code -801,-802?
What information is held in SYSIBM.SYSCOPY?
Outputs of explain are with matchcols = 0. What does this signify?
What is ALTER ?
How can record locking be achieved in those DB2 versions which do not support it?
How to resolve -504 sql code in DB2?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is the purpose of the QUIESE Utility?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Explain about mirror activator disk mirroring?
Which are the db2 tools to protect integrity of the database?