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 use timestamp datatypes
How to use online Backups?
How you can make a parameterized view?
What is DB Development software?
Explain the process of the user request and data generating?
Explain about query and reporting.
Explain about the storage and physical database design?
Write short notes on manual refreshes.
What is the physical representation for a many-to-many relationship?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Why does this query return 0?
What is dbms and its application?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What are the main phases of database development?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS