pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Which index is better for join operations
2+ messages / 2 participants
[nested] [flat]

* Which index is better for join operations
@ 1998-08-04 13:44  Chris Williams <chris_d_williams@itd.sterling.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Williams @ 1998-08-04 13:44 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Which index is better for join operations
@ 1998-08-04 14:16  Vadim Mikheev <vadim@krs.ru>
  parent: Chris Williams <chris_d_williams@itd.sterling.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Vadim Mikheev @ 1998-08-04 14:16 UTC (permalink / raw)
  To: Chris Williams <chris_d_williams@itd.sterling.com>; +Cc: pgsql-sql

Chris Williams wrote:
> 
> 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.

No. Also, keep in mind that btree-s are more stable and hash
index creation takes more time.

Did you run vacuum? Also, it's always good to build index after
copying data to tables - it's faster and updates statistic
about relation.

> The query is between 3 tables.  If you need any more details, please let me know.

Vadim



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-08-04 14:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-04 13:44 Which index is better for join operations Chris Williams <chris_d_williams@itd.sterling.com>
1998-08-04 14:16 ` Vadim Mikheev <vadim@krs.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox