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 |
Explain the use of the WHERE clause.
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is netezza database?
what is the maximum number of tables that can be joined ?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Is schema the same as database?
What is the difference between group by and order by?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is ibm db2 database?
What does db2 plan contain?
When reorg is used?
Can we insert update delete in view?