On Fri, Jan 16, 2009 at 8:47 AM, Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)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.