Обсуждение: 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 for your help,
M. Henaff

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