Impact of varchar/text in use of indexes

Поиск
Список
Период
Сортировка
От Mike Moran
Тема Impact of varchar/text in use of indexes
Дата
Msg-id 4050AF10.9060006@mac.com
обсуждение исходный текст
Ответы Re: Impact of varchar/text in use of indexes
Список pgsql-performance
Hi. I have two existing tables, A and B. A has a 'varchar(1000)' field
and B has a 'text' field, each with btree indexes defined. When I do a
join between these, on this field, it seems to a hash join, as opposed
to using the indexes, as I might expect (I'm no postgres expert, btw).

My question is: if I changed both fields to be text or varchar(1000)
then would the index be used?

Ta,

--
Mike



В списке pgsql-performance по дате отправления:

Предыдущее
От: brew@theMode.com
Дата:
Сообщение: Re: started Data Warehousing
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: compiling 7.4.1 on Solaris 9