12.07.2013, 10:55
Indices should increase performance. The index on name should increase performance when searching for the uid and the index on uid should increase performance when getting data for a specific uid.
//EDiT: The index on uid might be redundant as it is a primary key. I'm sure but it's possible that SQLite creates indices on primary keys by default.
//EDiT: The index on uid might be redundant as it is a primary key. I'm sure but it's possible that SQLite creates indices on primary keys by default.