Which index is better for join operations

Поиск
Список
Период
Сортировка
От Chris Williams
Тема Which index is better for join operations
Дата
Msg-id 005d01bdbfae$0eaac810$edfe04c7@itd.sterling.com
обсуждение исходный текст
Список pgsql-sql
I have a SQL statement that is SLOW and I am wondering if using a hash index instead of a btree on
the fields that are used for the join operations would be faster?  Anyone have any input on this.
The query is between 3 tables.  If you need any more details, please let me know.
Thanks
---------
Chris Williams
Sterling Software
Rome, New York
Phone: (315) 336-0500
Email: chris_d_williams@sterling.com


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

Предыдущее
От: James Olin Oden
Дата:
Сообщение: Re: [SQL] can a column be aliased?
Следующее
От: "William McCracken"
Дата:
Сообщение: Query based on date/time field