16.06.2016, 11:26
Sure it does. If the "Username" is not indexed and is also a text will obviously be slower searching than an indexed (primary keys are) integer.
Worth noting that any column is used in WHERE or ORDER BY must be indexed.
Worth noting that any column is used in WHERE or ORDER BY must be indexed.