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

Assignment Help:

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.


Related Discussions:- What is difference between primary index and secondary index

What is 2nf, What is 2NF? A relation schema R is in 2NF if it is in 1NF...

What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

Give an example of multiple inheritance, Give an example of multiple inheri...

Give an example of multiple inheritance.  One example of multiple inheritance is a committee for students affair which include faculty and administrative staff member.

Sql, find the name of supplier who supply some red part

find the name of supplier who supply some red part

Illustrate package classes and associations into models, Package classes an...

Package classes and associations into models  Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part

Object-based models - data models, Object-based Models: Use objects as key ...

Object-based Models: Use objects as key data representation components . Examples:-   Entity-Relationship Model: It is a collection of real world objects known as entitie

Define thomas write rule, Define Thomas write rule Thomas' write rule: ...

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

Define the boyce-codd normal form, Define the Boyce-Codd Normal Form with i...

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

Illustrate system design of an object oriented approach, System Design: An ...

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

What is a security, What is a security? Securities are claims on financ...

What is a security? Securities are claims on financial assets.  They can be illustrated as "claim checks" which give their owners the right to receive funds in the future.  Sec

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd