No, the above makes sense if you think of how sqlite would typically be accessing data... If

uid

is an index, then it's easy to iterate over that. You have to traverse the whole BTree to get the actual indexed data.