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 |
what is Static and dynamic linking
How do I create a view in db2?
how we will do null data selection in cobol-db2 program
What's the maximum number of volumes that can be added to a STOGROUP?
Which isolation level provides highest data integrity?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Is schema the same as database?
Is db2 a mainframe?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is a precompiler?