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

Question Posted / guest

1 Answers
13130 Views
IBM, I also Faced
E-Mail Answers

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

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers

Return code 100 means?

6 Answers Cap Gemini,

Highlight all the advantages that are attached to a package.

0 Answers

how can u nderstand the sql stmts executed successfully or not ?

1 Answers TCS,

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers

how to execute qcmdexc in rpgle?plz write code also?

1 Answers IBM,

What is runstats utility in db2?

0 Answers

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers Cap Gemini,

What is the use of value function?

0 Answers

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers

Why use RUNSTAT Utility?

3 Answers Merrill Lynch,

For more DB2 Interview Questions Click Here