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

Client dbms, i need to submit in this topic. i need to submit in this topic.

The file based system in dbms, The File Based System File based systems... The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Describe queries with complex types, Describe queries with complex types? ... Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

What are the different types of interfaces provided by dbms, Question 1 Su... Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

What does data dictionary is a special file contains, What does data dictio... What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

What is the purpose of storage manager, What is the purpose of storage mana... What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

What are stored and derived attributes, What are stored and derived attribu... What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

boyce codd normal form relations, Create centralized relational database u... Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

What are the uses of functional dependencies, What are the uses of function... What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set

Relational DB, Suppose R is a relation with attributes A1, A2,..., An. As a... Suppose R is a relation with attributes A1, A2,..., An. As a function of n, tell how many superkeys R has, if: 1.1 The only key is A1. 1.2 The only key is A1 and A2. 1.3 The o