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
- 31684 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / roshan jha
The index in which the sort order of a search key is similar
to the sort order of a relation then the index is called
primary index.Ex.front index of the book.
While in secondary index the order of the search key is in
different order from the order of the key in file.eg.index
in back side of some book.
Two entries are said to be duplicate if have same
value for the search key field associated.primary index
doesnot have duplicates.
| Is This Answer Correct ? | 27 Yes | 14 No |
Post New Answer View All Answers
Explain what a database is?
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
Which four data types cannot be used as a return type from a user-defined function?
Explain the role of indexing in databases?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about post-relational databases?
How long can an error message be in raiseerror function?
Explain the cube operator?
How to replace not in with not exist?
What is dbms and its application?
Who are end users in dbms?
Explain about the relational database?
What is the maximum length of an extended property?
Explain the rollup operator?
In which database can extended stored procedures be added?
