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

Differentiate between primary and secondary storage, Differentiate between ... Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Ldb hierarchy there should exist one get statement, It is mandatory that fo... It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False.  It is not essential.

Replicating data, Replicating Data One approach that may support effici... Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Transaction, what are the states of transaction? what are the states of transaction?

Note gate, i want notes on this topic i want notes on this topic

Database management issues, You are required to write a report which evalua... You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

What is mysql, What is MySQL? MySQL is a relational database management... What is MySQL? MySQL is a relational database management system which has eleven million installations. It can be used for both Linux and Window. Managing database includes add

Consider relational schema and construct algebra query, Consider the follow... Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

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.

Distinguish among a datareader class and a dataset class, Question (a) ... Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among