index question

[KashKurcura]

i have a multi field index on two fields because my query

SELECT * FROM Friends WHERE MemberID = '$MemberID and FriendID = '$FriendID'

now my question is i need to do a query like this in another area of my website.

SELECT * FROM Friends WHERE MemberID = '$MemberID

should i keep my multi field index the same or should i add another index on 'MemberID'?

hope someone can help me out.

[bastien]

add another

[KashKurcura]

gotcha, when i do that in phpmyadmin it gives me a warning about having two indexes for the same field? do i just ingnore that? 🙂