Nevermind, I see why it's using an index. There is a foreign key from group_users to the users table based on (col2, col5). So when I join by col2, it uses the index. If I use col5, it probably won't use the index since col2 is missing.