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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rebind in db2?

572


What is load utility in db2?

659


What is db2? Explain.

601


How to create backup table in db2?

638


What are the different types of base tables?

583






What types of tables are there in the db2 database?

548


What is dclgen (declaration generator)?

597


Which is faster delete or truncate?

671


What is a db2 collection?

603


How to test SQL -911 error while developing COB-DB2 program

6705


What parameters are used to control the free space in DB2?

640


what are bind concepts in db2 cobol?

645


What is a system catalog table in db2?

580


What is a plan and package in db2?

613


Mention data types used in db2 ?

668