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
I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim

(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

Define various ways in which SELECT statement can be used for record selection Technology?  SELECT gives you control over a number of aspects for record retrieval: 1) Which

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage

What are the various symbols used to draw an E-R diagram (any 3)?

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

sir, could anybody help me in getting complete information about the mentioned topic

Give an example of Object Representation  For illustration, consider the implementation of a social security number within an employee object that is shown in Figure. The soci