What is the difference between a primary index and a
secondary index? What is a duplicate data entry in an index?
Can a primary index contain duplicates?
Answer Posted / nusret sevinc
A primary index is an index on a set of fields that includes
the unique primary
key for the field and is guaranteed not to contain
duplicates. A secondary index
is an index that is not a primary index and may have
duplicates. Two entries are
said to be duplicates if they have the same value for the
search key field associated
with the index.
| Is This Answer Correct ? | 88 Yes | 20 No |
Post New Answer View All Answers
How to combine two function together?
Explain about a primary key?
What is an application role and explain a scenario when you would use one?
Explain the process of the user request and data generating?
How can I detect whether a given connection is blocked?
Which four data types cannot be used as a return type from a user-defined function?
What is the database development process?
Explain about relational database management systems?
In which table collections errors are stored.
What is dbms and its application?
Explain what a database is?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What is the physical representation for a many-to-many relationship?
Explain about relational operator join?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?