The database is for members who have subscribed to a service. I'd like to search the DB based on the user entry of a few fields, check if the member already exists, then return a set and let the user click their name (if found).
I believe I will need to use indexes here as the table will grow pretty large (between 200,000 and 500,000 records). My question is, what indexes will work best for each column? The fields the user will enter values for are:
BIRTH DATE (date)
The SELECT query would search the DB looking for a match. Your help is much appreciated, thanks.