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

Define forms based interfaces, Define Forms Based Interfaces? Forms-Bas... Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

Heuristics, Benefits of using heuristics Benefits of using heuristics

RDBMS, why data in an RDMS need to be normalised why data in an RDMS need to be normalised

What are the properties of transaction, What are the properties of transact... What are the properties of transaction? There are three properties of transactions :- A)     Atomicity B)      Consistency C)       Isolation

Define serializable schedule, Define Serializable schedule Serializable... Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

Define data model, Define data model? A data model is a collection of c... Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.

Implement a cache simulator, You are required to program (in a high level l... You are required to program (in a high level language such as C, C++, Java) and implement a cache simulator which will have the following inputs and outputs:- INPUTS

Describe sequential file organization, Describe sequential file organizatio... Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

#title., losers with new information systems losers with new information systems

In e-r diagram how generalization is represented, In E-R diagram how genera... In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.