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 |
What does runstats do in db2?
WHAT IS MEANT BY COMMIT COMMAND?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is the STOSPACE Utility used for?
Where could you look if you had a question about whether a column has been defined as an index?
what is diffrence b/w file-aid tool and file-aid utility???
What's The Percentage Free Space ?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is the physical storage length of the data types date, time, and timestamp?
What are foreign keys in db2?
what is different three logs in DB2?
What happens in bind step in a db2 program?