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 / roshan jha
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.eg.index
in back side of some book.
Two entries are said to be duplicate if have same
value for the search key field associated.primary index
doesnot have duplicates.
Is This Answer Correct ? | 27 Yes | 14 No |
Post New Answer View All Answers
How to use timestamp datatypes
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Which data type cannot be used as a parameter in a udf?
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 about relational database management systems?
Explain about relational operator join?
Explain about normal forms?
explain detail about ftp in datastage?
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?
What are the three basic rules which are to be followed for the relational model of the database?
How is data stored in dbms?
Who are naive users?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to customize error conditions.
fact table and dimension table containg one to many relationship or many to one relastionship