What is a composite index and how does it differ from a
multiple index?
- 1 Answers
- 4184 Views
- I also Faced
- E-Mail Answers
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 host variables in db2?
Explain correlated sub-queries.
Define buffer pool.
What is db2 optimizer?
How do I add a column to a table in db2?
When the like statement is used?
What is the maximum number of columns in a db2 table?
what is utility for parm lib
Define predicate?
What is dbrm library?
Mention the downsides of page level lock.
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a Foreign Key?
What do you mean by cursor?
Which command is used to remove all rows from a table?
