Subject | Table size and indexing |
---|---|
Author | Christian Gütter |
Post date | 2001-06-17T00:54:24Z |
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
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