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



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

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

Post New Answer

More DB2 Interview Questions

What is an instance in db2?

0 Answers  


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

0 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,






How can you display the current date & current time ?

7 Answers   Cap Gemini,


What is bind plan?

0 Answers  


How could one combine a set of incremental image copies into a single copy?

1 Answers  


What is DCLGEN ?

3 Answers  


Mention some fields that are a part of sqlca.

0 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


How does DB2 use multiple table indexes?

1 Answers  


Categories