Subject Table size and indexing
Author Christian Gütter
Hi,

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.

Perhaps some of you have already made some experiences to which
treshold (approx. no of records) it is useful not to use indexes?


TIA,

Christian