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 |
How can you find out the # of rows updated after an update statement?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is sqlca?
What is Reorg Recovery? when will you run it?
Is the primary key a clustered index?
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....?
How to know the primary key of a table without defining the primary key in the table?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is scrollable cursor in db2?
how will you retrieve first record in table
What is usage pointer in cobol?
What is the difference between primary key & unique index ?