Brenda,

There is no easy rule of thumb for indexes, except that less indexes are better not only for update speed, but for data integrity and reducing network traffic as well.

The minimum you will need are indexes on all keys (primary, foreign, candidate). Also, try to avoid indexes comprised of more than one field.

- Keith

>I had thought SQL does not use indexes. But in the Developer's Guide it says 'you should also index any fields involved in a join.'
>
>Also, what is the rule of thumb on number of indexes. Mainly how the number of indexes affect updating times.
>
>Looking for optimization information. Have always had my app in a small office with workers who are in the same office. Now they want to use it for the state of VA. Trying to learn about optimization tips and tricks .. and knowledge.
>
>Thanks
>
>Brenda