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
Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

We face problem of stock Opening balance and closing balance in Minus

Explain the two types of participation constraint.  Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

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

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.