Re: [ADMIN] problem creating hash index

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(1

[ADMIN] problem creating hash index

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. Thanks f