On Fri, Aug 26, 2005 at 10:59:50 -0000, RAJU kumar <raju_19db@xxxxxxxxxxxxxx> wrote: > > > i want to find out the difference between the btree index and hash index and how exactly the hash index work. Why? You probably don't want to use hash indexes as btrees are virtually always better in the current implementation.