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?

Question Posted / guest

1 Answers
4651 Views
I also Faced
E-Mail Answers

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

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 the difference between using bind () and rebind () methods of naming class?

0 Answers

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers CGI, Wipro,

What is ibm db2 database?

0 Answers

What is the difference between Where and Having Clause

7 Answers IBM, iFlex,

How to solved 818 error

4 Answers Keane India Ltd, Wipro,

What is the use of with ur in db2?

0 Answers

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers Fidelity,

What information is used as input to the bind process?