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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
In which database can extended stored procedures be added?
Who are naive users?
How to use online Backups?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Why does this query return 0?
Explain the rollup operator?
Explain about relational database management systems?
What is a database development?
Explain about the storage and physical database design?
What are the three types of database design?
What are the constraints on severity level in raiseerror?
Write short notes on manual refreshes.
Explain about a primary key?