What is difference between primary index and secondary index, Database Management System

What is difference between primary index and secondary index?

Primary Index

a) It is an ordered file whose records are of fixed length along with two fields.

b) Only based upon the primary key.

c) The total number of entries in the index is similar as the number of disk blocks in the ordered data file.

d) Primary index is a king of nondense (sparse) index.

e) There might be at most one primary index for a file

f) Requires less storage space.

Secondary index

a) It offers a secondary means of accessing a file for which a few primary access already exists.

b) May be relies on candidate key or secondary key.

c) It comprises large number entries because of duplication.

d) Secondary index is a type of dense index.

e) There may be much more than one secondary indexes for the same file.

f) Requires more storage space and longer search time.

Posted Date: 5/6/2013 4:16:53 AM | Location : United States







Related Discussions:- What is difference between primary index and secondary index, Assignment Help, Ask Question on What is difference between primary index and secondary index, Get Answer, Expert's Help, What is difference between primary index and secondary index Discussions

Write discussion on What is difference between primary index and secondary index
Your posts are moderated
Related Questions
coventions for displaying an ER schema as ER diagram

What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y

what are the main characteristics of database

1.Suppose you are given a dataset that consists of a random sample of tasters, on which the following variables were obtained: (y) Zpref = taste preference for green beans store

Explain the difference between optimistic locking and pessimistic locking. Optimistic locking supposes no transaction conflict will occur and deals with the consequences if it

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

What are the several forms of identity? a) Value b) Name c) Built-in

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass