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 the difference between static and dynamic SQL?
If I have a view which is a join of two or more tables, can this view be updateable?
Explain about rct in db2?
What is the use of predicate?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What's the maximum number of volumes that can be added to a STOGROUP?
How to check sequence on a table in db2?
What are foreign keys in db2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is isolation level in db2?
What is reorg in database?
How can you find out the # of rows updated after an update statement?