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
- 31595 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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Write the fastest query to find out how many rows exist in a table?
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?
How long can an error message be in raiseerror function?
Can an extended stored procedure be called from inside a user-defined function?
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?
Explain the cube operator?
What is dbms explain in brief?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How would you design a database for an online site, which would average a million hits a day?
What is DB Development software?
Explain about the database management systems.
In which database can extended stored procedures be added?
Explain about query and reporting.
