Re: problem creating hash index

Поиск
Список
Период
Сортировка
Искать

Re: problem creating hash index

От:
Mathieu Arnold <arn_mat@club-internet.fr>
Дата:


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

problem creating hash index

От:
HENAFF Mari-mai FTRD/DMI/LAN <marimai.henaff@rd.francetelecom.fr>
Дата:
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
FAQ