Hi, 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. Thanks. Velen