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 are the various data types available in db2?
What is bind and rebind in db2?
What are bind parameters in db2?
Is db2 free?
How do I delete a table in db2?
What is the reason behind not using select * in embedded sql programs?
Explain db2.
What is runstats and reorg in db2?
What is the physical storage length of the data types date, time, and timestamp?
How to restart a DB2 program?
What are the bind parameters ibm db2?
What does reorg do in db2?
What are the 2 sqlcodes that are returned?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can you count the number of rows from a table tab?