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
What is dbms explain in brief?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How you can make a parameterized view?
How to use timestamp datatypes
What is database design and development?
Can an extended stored procedure be called from inside a user-defined function?
How can you log an error to the server event log from a stored procedure?
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
How to customize error conditions.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
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
Explain the role of indexing in databases?
Explain about the database management systems.
How to use online Backups?
In which database can extended stored procedures be added?