If I a tables primary key is (username, title, start_date)...I'm guessing it will create an index on (username, title, start_date).

If I'm querying by username, start_date, will it still use the index OR do I need to add an extra index for username, start_date)?