|
Related Questions |
View Answer |
|
What happens to the PLAN if index used by it is dropped?
|
View Answer
|
|
What else is there in the PLAN apart from the access path? ?
|
View Answer
|
|
What is ACQUIRE/RELEASE in BIND?
|
View Answer
|
|
What is a DBRM, PLAN ?
|
View Answer
|
|
What is ALTER ?
|
View Answer
|
|
Can I use LOCK TABLE on a view?
|
View Answer
|
|
What are the various locks available?
|
View Answer
|
|
What is lock escalation?
|
View Answer
|
|
What are the disadvantages of PAGE level lock?
|
View Answer
|
|
How does DB2 determine what lock-size to use?
|
View Answer
|
|
What are the various locking levels available?
|
View Answer
|
|
When do you specify the isolation level? How?
|
View Answer
|
|
Where do you specify them ?
|
View Answer
|
|
What is the difference between CS and RR isolation levels?
|
View Answer
|
|
What are the isolation levels possible ?
|
View Answer
|
|
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)
|
View Answer
|
|
How do you do the EXPLAIN of a dynamic SQL statement?
|
View Answer
|
|
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
|
View Answer
|
|
Where is the output of EXPLAIN stored? ?
|
View Answer
|
|
What do you need to do before you do EXPLAIN?
|
View Answer
|