What is a composite index and how does it differ from a
multiple index?
Answer / 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 |
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is iseries database?
Is db2 a mainframe database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
How is a typical db2 batch pgm executed?
i have a db2 variable how do u declare tht into working storage section ?
What can the SET option of the Repair Utility accomplish?
What is reorg?
What is a collection?