Tom Lane wrote:
> rihad <[EMAIL PROTECTED]> writes:
> > Given this table:
> > CREATE TABLE foo (
> > id integer primary key,
> > bar_id integer references bar (id)
> > );
> > and provided that bar.id is itself a PK, do I still need to create an
> > index on bar_id if often doing queries
rihad <[EMAIL PROTECTED]> writes:
> Given this table:
> CREATE TABLE foo (
> id integer primary key,
> bar_id integer references bar (id)
> );
> and provided that bar.id is itself a PK, do I still need to create an
> index on bar_id if often doing queries like:
> SELECT MIN(id) FROM foo
