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 in db2?
Define buffer pool.
List out the buffer pools in db2
What is difference between isnull and coalesce?
Mention the downsides of page level lock.
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
How is deadlock resolved?
How to retrieve rows from a db2 table in embedded sql?
What is a db2 collection?
B37 abend during spufi?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Can we update view in db2?
How to rename a table in DB2 ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Explain dclgen.