Which index is better for join operations

From: "Chris Williams" <chris_d_williams(at)itd(dot)sterling(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Which index is better for join operations
Date: 1998-08-04 13:44:48
Message-ID: 005d01bdbfae$0eaac810$edfe04c7@itd.sterling.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sterling(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message William McCracken 1998-08-04 14:09:31 Query based on date/time field
Previous Message James Olin Oden 1998-08-04 12:26:16 Re: [SQL] can a column be aliased?