So i basically have a link table connecting the user to an event, the structure is basically this:
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.
SELECT * FROM pointstable where userID='xyz123';
Thanks for the help,