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

Extended e-r features, Although, the essential features of E-R diagrams are...

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need

What are the states of transaction, What are the states of transaction? ...

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

What is dml query langauge, What is DML Query Langauge? Data Manipulati...

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

Data modelling and normalization methodology, MOSS VALE is a town with 1500...

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

Log, what is the need of a log in dbms

what is the need of a log in dbms

Cascading, what is cascading? what is rollback cascading? please explain in...

what is cascading? what is rollback cascading? please explain in detail

Illustrate the definition of the classes and operation, The definition of t...

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Explain consistency model , Explain in detail the consistency model of the ...

Explain in detail the consistency model of the distributed file system you studied (GFS or AFS). Present the consistency model chosen and how it was achieved through design. Clarit

Digital, #floating point representation is used to store

#floating point representation is used to store

What is the need of a log in a dbms, What is the need of a log in a DBMS? B...

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

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