Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between TYPE 1 index & TYPE 2 index
- 1 Answers
- 13231 Views
- IBM, I also Faced
- E-Mail Answers
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
| Is This Answer Correct ? | 20 Yes | 4 No |
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is DB2 (IBM Database 2)?
How will you delete duplicate records from a table?
In terms of DB2 indexing, what is the root page?
What is the connection string to connect to the DB2 Database ?
What technique is used to retrieve data from more than one table in a single SQL statement?
What are some characteristics of columns that benefit from indexes?
Why do we bind in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain what are the various isolation levels possible?
Before you give the explain statement, what are the prerogatives?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
COBOL 
