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 check last update on table in db2?

1057

What is the use of runstats in db2?

1104

What is db2 and what is the use of db2 optimizer?

1056

What is innodb buffer pool?

1049

What is lock escalation in db2?

1029

Can we update view in db2?

1000

What is table space in db2?

1014

What is the purpose of rollback and commit?

1190

What are the benefits of using the db2 database?

1224

How can you count the number of rows from a table tab?

1086

What is a dbrm in db2?

1020

How can record locking be achieved in those DB2 versions which do not support it?

1074

What does db2 plan contain?

1019

Is db2 relational database?

973

What is ibm db2 database?

998