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