> I am wondering how many records a table must contain so that
> indexing does not slow down selects.
>
> I have some very small tables with 25 up to 75 records which
> usually are not changed very often.
> I heard when using very small tables, indexes are not needed
> because they produce too much overhead.

It depends not only on number of records, but also on their width and page size -
the narrower (compressed) size of records and the larger page size,
the more records fit on one page.
I guess your tables should fit on one or two pages, so using indexes
is just unnecessary i/o overhead (or wasting cache space).

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase