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

There are 6561 cricket balls out of them 1 is heavy. Find the minimum no. of times the cricket balls have to be weighed for finding out the heavy ball.

715


Certain no. of men can finish a piece of work in 10 days. If however there were 10 men less it will take 10 days more for the work to be finished. How many men were there originally.

778


Q.19 Alok and Bhanu play the following min-max game. Given the expression N=9+X+Y–Z where X, Y and Z are variables representing single digits (0 to 9), Alok would like to maximize N while Bhanu would like to minimize it. Towards this end, Alok chooses a single digit number and Bhanu substitutes this for a variable of her choice (X, Y or Z). Alok then chooses the next value and Bhanu, the variable to substitute the value. Finally Alok proposes the value for the remaining variable. Assuming both play to their optimal strategies, the value of N at the end of the game would be 27 18 20 Answer is: 20 can someone plzzzzzzzzz tell me how this answer is calculeted???

2455


If the operation,^ is defined by the equation x ^ y = 2x + y,what is the value of a in 2 ^ a = a ^ 3

782


'X' liters of petrol can be filled in an automobiles tank. What part of full tank was removed, if 'Y' liters was removed when the tank was full?

691






tickets numbered 1 to 20 are mixed up and then a ticket is drawn at random. What is the probability that the ticket drawn has a number which is a multiple of 3 or 5?

752


A tailor has 37.5 metres of cloth and he has to make 8 piecesout of a metre of cloth. How many pieces can he make out of this cloth?

686


A person starts walking at a speed of 5km/hr through half the distance, rest of the distance he covers with a speed 4km/hr. Total time of travel is 9 hours. What is the maximum distance he can cover?

1170


In a mixture R is two parts, S is one part . In order to mixture how much R is to be added.

888


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.

780


If ABC =C3C3 and CAB = D3D3, Then find D3÷B3D3÷B3

970


Four friends are given named Akansha, Anuska, Anisha, ... , ... Each of them live in a separate home and sleep on one bed. Akansha and Anuska have two extra beds, two of the house have green lawns while the rest have narrow porchs, One of the house has Airconditioner while the rest have fans

2557


If A=Z, B=Y, C=X, .......... Z=A, Then ZERD = ?

764


wind flows 160 miles in 330 min, for 80 miles how much time required.

839


WHAT IS THE NUMBER OF ZEROS AT THE END OF THE PRODUCT OF THE NUMBERS FROM 1 TO 100

677