Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 32324 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / khadija
1.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.
2.Example,
Employee ID can be Example of it. Example,
Employee name can be example of it. Because Employee name can have similar values.
3.The primary index contains the key fields of the table. The primary index is automatically created in the database when the table is activated. If a large table is frequently accessed such that it is not possible to apply primary index sorting, you should create secondary indexes for the table.
4.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. Ex, index
in back side of some book.
5.In the case of
Primary Index both keys and addresses of the records are
kept in order to search a particular record faster. In the case of Secondary Index only the addresses of the
records are kept in the index not the key.
6.There can be only one primary index. There can be many secondary indices.
| Is This Answer Correct ? | 0 Yes | 0 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?
Explain about post-relational databases?
What is an application role and explain a scenario when you would use one?
What is normalization? Explain different levels of normalization?
Explain about the hierarchical model of the database?
Explain about xml databases?
How to generate OIDS
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?
Where is dbms used?
What are the 18 schemas?
Explain the cube operator?
How to use timestamp datatypes
In which table collections errors are stored.
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?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
