Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to the PLAN if index used by it is dropped?
- 1 Answers
- 5679 Views
- I also Faced
- E-Mail Answers
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 |
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Is db2 a programming language?
What is the syntax required for the creation of a cursor?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Outputs of explain are with matchcols = 0. What does this signify?
How and when does the db2 enforces the unique key?
What is EXPLAIN?
How many buffer pools are there in DB2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
COBOL 
