What is primary index, Database Management System

Primary Index

In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

Dense primary index: the number of entries in the index table is the similar as the number of entries in the major table. In other words, each and every record in the major table has an entry in the index.

Sparse or Non-Dense Primary Index:

For large tables the Dense Primary Index itself starts to grow in size. To keep the size of the index smaller, instead of pointing to each and every record in the major table, the index points to the records in the main table in a gap.

 

Posted Date: 7/26/2013 6:59:52 AM | Location : United States







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

Write discussion on What is primary index
Your posts are moderated
Related Questions
Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

explain the level architectures of the database management system

Which component is not included in database environment ? A users component is not included in database environment.

Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

Conflicting Operations in Schedule: The three simple ways of interleaved instruction implement of transactions T1 and T2. Please note that in the following tables the first col

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

Explain forms based and graphical interface? Forms based and graphical interface: graphical user interface (GUI) is a kind of user interface which permits people to interact

How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Show, with the help of an example, that relatively high-level transitions result when system or program is stimulated by the outside events. In diagram below, we can observe i