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 / 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 to replace not in with not exist?
What are the main phases of database development?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How to generate OIDS
Explain about the database management systems.
Write the fastest query to find out how many rows exist in a table?
Explain about relational database management systems?
Explain about query and reporting.
Explain about the relational database?
Explain the process of the user request and data generating?
Explain about xml databases?
What are the key features of dbms?
How you can make a parameterized view?
Why does this query return 0?