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

Locks, Locks: Serialisabilty is just a test whether a given interleaved sch... Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

Attribute preservation, Attribute Preservation This is a easy and obvio... Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

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

Define view? how it is related to data independence, A View may be defi... A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Which sorting technique is used to sort databases, Which sorting technique ... Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

Define the terms ddl and dml, Define the terms i) DDL ii) DML DDL: Data... Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data

Differance between procedural and non procedural dml, Differance between pr... Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural

Database Management System, assignment assignment

Differentiate between horizontal and mixed partitioning, Question: In r... Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

Tables, does tables are called relations does tables are called relations