On Fri, Jan 16, 2009 at 8:47 AM, Bruno Lavoie <bruno.lav...@gmail.com> wrote: > Hello, > > are these statements true: > > «You should always index fks. The only exception is when the matching unique > or primary key is never updated or deleted» ?
No. If the table that fks to another table has 10 rows and will never have more than a few hundred, why index it? > «Small tables do not require indexes» ? Usually true, except for unique indexes, which provide more functionality than just indexing. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
