What is secondary index, Database Management System

What is Secondary Index

While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary memory (Hard Disk). Theoretically, a table may have millions of records (as the telephone directory of a large city), for which even a sparse index becomes so large in size that we cannot keep it in the primary memory. And if we cannot keep the index in the primary memory, then we lose the benefit of the speed of access. For very large table, it is better to classify the index in multiple levels.

 

Posted Date: 7/26/2013 7:00:39 AM | Location : United States







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

Write discussion on What is secondary index
Your posts are moderated
Related Questions
Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Need an expert in ER database theoretical and modeling database system Project Description: Need an expert in ER database theoretical and modeling database systems? Skills

what is cascading? what is rollback cascading? please explain in detail

Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules


What are the disadvantages of relational approach? Disadvantages of relational approach: • Substantial hardware and system software overhead • May not fit all business models •