At 07:27 PM 16-06-01 -0700, you wrote:

> >
> >Indexes on small ("control") tables won't slow anything down, since the
> >tables are usually pretty static anyway and you are not going to be
> >performing huge bulk inserts or deletes to them. Some would say that it's
> >not worth indexing them but you are using IBO, which makes good use of
> >indexes.
>
>How about indexes on tables containing purely "reference data?" Tables
>containing 25 to 100 rows, rarely changed, read into a memory structure at
>execution time?
>
>No joins, no sorting.

You are talking about "lookup tables", a la the TDataset TTable, right? No, if I was still designing applications like that, around a database that didn't support joins, I wouldn't index such a table. There would be no need for it.

--- H
All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________