Re: Many-To-Many Bridge Table Index

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/