Subject Re: [ib-support] Table size and indexing
Author Charles Stanley
>
>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.