>It depends on how many records are in the table

About 80,000 175-byte records. There are 44 fields and 27 of them are indexed. My plan is to remove the index from about 10 fields and do some speed comparisons.


The main query trade-off is the difference between downloading (over an Ethernet network) a larger preliminary result set (OPTIMIZE OFF) or a larger bit map (OPTIMIZE ON). Assuming that there are enough records to matter (more than 1000 ?), I don't see why the number of records would effect the trade-off.

As the number of records grows larger, the priliminary result set gets larger but so does the bit map which must be downloaded.

Has anyone done any testing?


>and what effect it will have on queries based on that field.

That's the effect that I want to predict.


Peter