Subject | Re: [ib-support] Table size and indexing |
---|---|
Author | Charles Stanley |
Post date | 2001-06-17T02:27:24Z |
>How about indexes on tables containing purely "reference data?" Tables
>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.
containing 25 to 100 rows, rarely changed, read into a memory structure at
execution time?
No joins, no sorting.