TYPE 1 index has subpages and uses index locking. TYPE 2 index has no sub

What is the difference between TYPE 1 index & TYPE 2 index

Question Posted / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to run db2 command in windows?

1241

What is the use of runstats in db2?

1178

How many types of page locks can be held in db2?

1087

What is the result of open cursor statement?

1125

Is the primary key a clustered index?

1200

How do I connect my db2 database to ibm?

1084

Give a brief description of db2 isolation levels?

1138

What is the syntax for seeing the columns and data types of a table in the db2 database?

1230

What is the difference between bind and rebind in db2?

1505

How would you find out the total number of rows in a db2 table?

1094

What is performance tuning db2?

1109

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1156

List some fields from sqlca?

1105

Explain about open switch business continuity software?

1183

What are the various data types available in db2?

1143