Please keep replies posted to the list so that more people can add to and learn from the discussion. On Sat, Aug 27, 2005 at 08:18:57 -0000, RAJU kumar <raju_19db@xxxxxxxxxxxxxx> wrote: > Sir i am a consultant in Sql * international india, > And the problem with me is i have to handle all the question regarding oracle i now how btree works and also about bitmap but i want to know abt hash index and how and where we should use it. > Hope u will help me . > raju The short answer is that you don't want to use hash indexes in postgres.