how many types of indexing?

Answer Posted / harish rawat

Index is a method used for faster retrieval of
records.different types of indexes are
1.primary key index
2.unique index
3.bitmap index
4.hash index
5.function based index
6.B-tree index(default index created) on table.
7.Virtual index

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

p and q are positive integers with their average 5, find how many different values can p take

987


Scientific publishing aptitude interview question

1272


There is 12 perls. One of them is either light or heavy than others. There is a weighing pan. How many trials are needed to find the exceptional one.

1012


Two trains are travelline at equilateral .Train A is travelling in the direction of earths spin.Other train B is travelling in opposite direction of earths spin.Which trains wheels will wear first?and why?

1437


If the product of three consecutive int is 210,then sum of the two smaller ints is:

1006


Name of the cipla medicine product

4538


A robber steals half the total no of pastry plus 1/2 tray from a pastry shop. A second robber steals half the remaining no of pastry plus 1/2 tray and so on. After the 5th thief has stolen there are no more pastry left in the pastry shop. What was the total no of pastry did the pastry shop have at the beginning.

1066


Given the length of the 3 sides of a triangle.Find the one that is impossible? (HINT : sum of smaller 2 sides is greater than the other one which is larger)

1048


A pipe can fill a tank in 30 min B can fill in 28 min then if 3/4 th of tank can be filled by B pipe and after wards bothare opened then how much time is required by both the pipes to fill the tank completely. note: the values of A and B may slitely vary be ware.

1105


A batsman scores 23 runs and increases his average from 15 to 16. Find the runs to be made if he wants top Inc the average to 18 in the same match.

1083


the decimal number was given.it was converted to other system.they asked to identify the system.i.e. octal,hexadecimal.

934


There are two glasses, one is filled with orange juice and other is filled with apple juice both in equal quantities say 50 50 ml. 50% orange juice is poured in apple juice and than the 50% mixture of orange and apple juice is poured in the glass of orange juice. Now you have to find out how much orange juice is there in apple juice glass and vice-versa.

1120


PA and PB are tangents to the circle at A and B respectively and the chord BC is parallel to tangent PA. If AC = 6 cm, and length of the tangent AP is 9 cm, then what is the length of the chord BC?

1262


Mary's father's brother is Andrews Andrews daughter's son is Sunil Brothers name is Sam Who is Sam to Sunil?

1445


A boy multiplied a number with 10 and got 100,instead of dividing it . If he divided it what would be the answer?

1302