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
- 32456 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
What are the main phases of database development?
Explain what a database is?
How to use online Backups?
Which data type cannot be used as a parameter in a udf?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about a primary key?
Can an extended stored procedure be called from inside a user-defined function?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about post-relational databases?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
fact table and dimension table containg one to many relationship or many to one relastionship
What is an application role and explain a scenario when you would use one?
What are the three types of database design?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
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?
