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

Explain the role of a database administrator, Explain the Role of a databas...

Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

Describe physical data independence, Describe Physical Data independence ? ...

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

The logical dbms architecture, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE

Define instance and schema, Define instance and schema?  Instance:  C...

Define instance and schema?  Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database.  Schema: The o

Describe dynamic model, Describe Dynamic Model. The dynamic model speci...

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

ER model, coventions for displaying an ER schema as ER diagram

coventions for displaying an ER schema as ER diagram

What is deadlock, What is deadlock? How can it be avoided? How can it be re...

What is deadlock? How can it be avoided? How can it be resolved once it occurs? Deadlock happens when two transactions are each waiting on a resource that the other transaction

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Online Bakery Data Base Project, How much would you charge to create a data...

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Oracle, I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am exper...

I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am expert in assignements & Online tutoring so i want to join you. Please guide me. Thanks Brajesh Shukla +91 9899641535

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