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 sqlca’s maximum length?

0 Answers  


How to check last update on table in db2?

0 Answers  


What is universal database?

0 Answers  


If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  


What is the latest version of ibm db2?

0 Answers  






How do I connect my db2 database to ibm?

0 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


Explain the benefits you can get from mainframe connect?

0 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is bind and rebind in db2?

0 Answers  


Describe major components of db2?

0 Answers  


What is dclgen (declaration generator)?

0 Answers  


Categories