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
- 30701 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjib sarkar
Index is a set of <KEY,ADDRESS> pair. Now in the case of
Primary Index both keys and addresses of the records are
kept in order to search a particular record faster but in
the case of Secondary Index only the addresses of the
records are kept in the index not the key.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How would you design a database for an online site, which would average a million hits a day?
Can an extended stored procedure be called from inside a user-defined function?
What is dbms explain in brief?
Explain about the storage and physical database design?
In which database can extended stored procedures be added?
How to combine two function together?
How is data stored in dbms?
Write short notes on manual refreshes.
How can you log an error to the server event log from a stored procedure?
I have a few records all are same structures data, I want to store data in multiple targets how
How can I detect whether a given connection is blocked?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about query and reporting.
What is a database development?
Explain the cube operator?
