Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest


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 a db2 package?

0 Answers  

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

Can I use LOCK TABLE on a view?

1 Answers  

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

What is ibm db2 connect?

0 Answers  

How do I add a column to a table in db2?

0 Answers  

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

What is lock contention?

1 Answers  

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

How to resolve deadlock issue

5 Answers   IBM,

define clustering index.

0 Answers  

For more DB2 Interview Questions Click Here
Categories