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
What is null value in db2?
What type of database is db2?
What are the two types of logging in the db2 database? Explain them.
Mention the definition of cobol in varchar field.
What is the difference between using bind () and rebind () methods of naming class?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Why do we bind in db2?
Can you use max on a char column?
What is cascading rollback?
How to view db2 table structure?
What is data manager?
How can we retrieve the total number of records in RPG & CLLE?
What are host variables in db2?
What parameters are used to control the free space in DB2?
What is the difference between drop table and delete table?