Re: [ADMIN] problem creating hash index

[Mathieu Arnold]

HENAFF Mari-mai FTRD/DMI/LAN wrote:
> 
> Hi,
> 
> I have a problem creating a hash index : it's too slow (it takes several
> days, i stopped it before the end).
> When i create a b-tree index on the same field, it takes approximately
> twenty minutes.
> The type of the field indexed is Varchar(16). The table indexed contains 20
> MO of rows.

what's the difference between b-tree and hashed indexes ?

-- 
Mathieu Arnold