What is a composite index and how does it differ from a
multiple index?



What is a composite index and how does it differ from a multiple index?..

Answer / s

Composite index consists of two or more columns
A tablespace can have multiple indexes.
But the column to be indexed can only appear once in the
index

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

what is Static and dynamic linking

1 Answers   Virtusa,


How do I create a view in db2?

0 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


Which isolation level provides highest data integrity?

0 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  


Is schema the same as database?

0 Answers  


Is db2 a mainframe?

0 Answers  


What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  


Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,


What is a precompiler?

2 Answers  


Categories