My question is about indexes...basically, I'm wondering how many indexes is
too much, and what the drawbacks are of having more indexes on a table? I'm
guessing INSERT and UPDATE queries probably take longer?
My table has the following fields:
member_id, first_name, last_name, username, password, email, street1,
street2, city, state, zip, country_id, signup_date, signup_ip, ref_id, sex,
age, income
I know for sure I will want to index the username and email fields. However,
should I index the entire field, or would 5 or 6 characters be enough to
index? I will also be selecting BY country_id, signup_date, and ref_id as
well, is it okay to index all of them? I will also be using the signup_ip
field to delete duplicate accounts, should I therefore index that field so
the "distinct" operator works better?
Is it okay to have 6 indexes on a table like this? The table may have
upwards of a million entries.
TIA!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
