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

Ask an Expert

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

Write your message here..

Related Questions

Describe the most important classes of parallel machines, Question 1 Discu... 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, Explain how the as... 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

single products ordered, For Colorado customers calculate the number of si... 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

Project on designing and creating a database , This project will involve de... 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

Information system fundamentals, A full discription of the new, a discripti... 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

Er database theoretical and modeling database system, Need an expert in ER ... 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

Cascading, what is cascading? what is rollback cascading? please explain in... what is cascading? what is rollback cascading? please explain in detail

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

Ddlc, ddlc ddlc

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