What are the two types of indices?

The two types of indices are:-

A)     Dense index

B)      Sparse index

 

Posted Date: 6/1/2013 6:53:55 AM | Location : United States

Ask an Expert

Related Discussions:- What are the two types of indices, Assignment Help, Ask Question on What are the two types of indices, Get Answer, Expert's Help, What are the two types of indices Discussions

Write discussion on What are the two types of indices
Your posts are moderated

Write your message here..

Related Questions

Search the salary of employees who are not ‘analyst’ , Example- Search the ... Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP

Create a database, Project: Microsoft Access You have been asked by the ... Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

Record based logical models, Record based Logical Models: Use records as th... Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

Write a short note on qbe, Write a short note on QBE? Stands for "Quer... Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Datawarehouse, Explain four causes for failures in data warehouse projects Explain four causes for failures in data warehouse projects

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS... Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

State the process of inheritance adjustment, Inheritance Adjustment As... Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def

The external or view level in dbms, The External or View Level The ex... The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see

Query to delete constraint from alter table, A constraint named less_than_2... A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;