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

A bus started from bustand at 8.00a m and after 30 min staying at destination, it returned back to the bustand. the destination is 27 miles from the bustand. the speed of the bus 50 percent fast speed. at what time it retur4ns to the bustand

1020


Delhi's population is increasing day by day what is the reasong behind it & how can we solve it. G.D QUESTION (amit_nirwan@yahoo.com)

2527


All birds are animals. All animals are four legged. Implications a. All animals which are four legged are birds. b. All birds are four legged c. Some birds are four legged d. Some birds are animals but not four legged.

1587


Ram, Shyam and Gumnaam are friends.Ram is a widower and lives alone and his sister takes care of him. Shyam is a bachelor and his niece cooks his food and looks after his house. Gumnaam is married to Gita and lives in large house in the same town. Gita gives the idea that all of them could stay together in the house and share monthly expenses equally. During their first month of living together, each person contributed Rs.25. At the end of the month, it was found that Rs 92 was the expense so the remaining amount was distributed equally among everyone. The distribution was such that everyone received a whole number of Rupees. How much did each person receive?

1230


A chain is broken into three pieces of equal lenths containing 3 links each. It is taken to a backsmith to join into a single continuous one . How many links are to to be opened to make it ?

1215


CALIBRATION PROCEDURE FOR HPLC

2303


What is the probability of getting 3 or 4 in 3 consecutive rolls of a dice ?

2121


What is the error in the given sequence. 2,3 6,7 14,15 29,46.

958


What is the perimeter of the quadrilateral?

908


A vegetable seller sells his vegetables at the rate of Rs. 9 kg and thereby incurs a loss of 20%. If he had to make a profit of 5%, at what price per Kg should he sell his vegetables?

1264


Fathers age is 5 times his son's age. 4 years back the father was 9 times older than son.Find the fathers' present age.

1167


A certain type of mixture is prepared by mixing brand A at Rs.9 a kg. with brand B at Rs.4 a kg. If the mixture is worth Rs.7 a kg., how many kgs. brand A are needed to make 40kgs. of the mixture?

1354


if x/y =4 and y is not '0' what % of 'x' is '2x-y'

963


What number should be added to or subtracted from each term of the ratio 17 : 24 so that it becomes equal to 1 : 2.

927


hai am Deepak here i have my exam on 3rd jan 2010 for the post of officers job in karnataka bank so kindly plz send me model papers . thank u

2770