|
Related Questions |
View Answer |
|
64) What happens to the PLAN if index used by it is dropped?
|
View Answer
|
|
63) What else is there in the PLAN apart from the access path? �
|
View Answer
|
|
62) What is ACQUIRE/RELEASE in BIND?
|
View Answer
|
|
61) What is a DBRM, PLAN ?
|
View Answer
|
|
60) What is ALTER ? �
|
View Answer
|
|
59) Can I use LOCK TABLE on a view?
|
View Answer
|
|
59) Can I use LOCK TABLE on a view?
|
View Answer
|
|
58) What are the various locks available?
|
View Answer
|
|
57) What is lock escalation?
|
View Answer
|
|
56) What are the disadvantages of PAGE level lock? - RAMESH www.geocities.com/srcsinc
|
View Answer
|
|
55) How does DB2 determine what lock-size to use?
|
View Answer
|
|
54) What are the various locking levels available?
|
View Answer
|
|
53) When do you specify the isolation level? How?
|
View Answer
|
|
52) Where do you specify them ?
|
View Answer
|
|
51) What is the difference between CS and RR isolation levels?
|
View Answer
|
|
50) What are the isolation levels possible ? �
|
View Answer
|
|
49) 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
|
|
48) How do you do the EXPLAIN of a dynamic SQL statement?
|
View Answer
|
|
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? �
|
View Answer
|
|
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? �
|
View Answer
|