Interested to Buy Any Domain ? << Click Here >> for more details...
What is a composite index and how does it differ from a
multiple index?
- 1 Answers
- 4752 Views
- I also Faced
- E-Mail Answers
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
What's The Percentage Free Space ?
What is scrollable cursor in db2?
Why do we use cursor?
What is the maximum size of varchar data type in db2?
List down the types of triggers in the db2 database?
What is consistency token in db2?
What is plan in cobol db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are the contents of a dclmgen?
What is the difference between drop table and delete table?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is db2 optimizer?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Explain in detail about buffer manager and its functionalities?
What are db2 objects?
