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?
- 5 Answers
- 30741 Views
- IBM, I also Faced
- E-Mail Answers
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
State the acid rules?
Which data type cannot be used as a parameter in a udf?
Who are naive users?
How to use online Backups?
What are the main phases of database development?
What are the key features of dbms?
What are the constraints on severity level in raiseerror?
How can you log an error to the server event log from a stored procedure?
What are the types of database model?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How long can an error message be in raiseerror function?
How to use timestamp datatypes
Explain about xml databases?
Explain about post-relational databases?
How can you fix a poorly performing query?
