Re: Many-To-Many Bridge Table Index

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Sergei Dubov <sdubov(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Many-To-Many Bridge Table Index
Date: 2005-09-30 06:54:47
Message-ID: 200509300854.47986.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Donnerstag, 29. September 2005 21:44 schrieb Sergei Dubov:
> select * from table_a where table_b_id=1,
>
> will the query use an index? Will this be true when I do join on this
> table?

It could use the index, but whether it will depends on the particular data
distribution. The EXPLAIN command is your friend.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2005-09-30 06:56:46 Re: postmaster does not shut down
Previous Message Peter Eisentraut 2005-09-30 06:52:35 Re: security documentation