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
Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

discuss the array implementation of a stack.

a project based on normalization with first, second and third normalization. There need to be a diagram also

Define the terms i) Entity type ii) Entity set Entity type: An entity type describes a collection of entities that have the similar attributes. Entity set: The set of all en

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

State your technical objectives for mining the data. Data Understanding. Describe the data For each attribute, give its description and data type. For numeric attributes

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet