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
What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

define locking in simple language and decribed it

What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.

A database administrator''s responsibilities and data contents


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