I have a table containing 75 fields with a primary index and index set on 5 other fields.
Everything is working fine so far as the table contains only about 80,000 records. I
expect these records to reach 500,000 by end of september.
I would like to know:
- if the number of records will slow down my queries when I search on the indexed fields?
- if manipulating the records within the table will be slow, (i.e. insert into table...,
delete from table..., subqueries)
Can anyone advise? Also, if you have a similar table please let me know your pros and
cons for this kind of table structure.