Hi,

So i basically have a link table connecting the user to an event, the structure is basically this:

pointstable
userID
eventID
mark1
mark2


This table is massive with each user having about 24 entries and there are alot of users. I was just wondering if there is a way that i could optimise the select query or if MySQL does the optimisation for me.

Query example:

SELECT * FROM pointstable where userID='xyz123';

Thanks for the help,
Nick