I don't know, if the author of SQLite also reads here, but ... I am not sure, if having a single key space seems to have possible counter-productive effects on

I don't know, if the author of SQLite also reads here, but ... I am not sure, if having a single key space seems to have possible counter-productive effects on the overall speed. One example: You want to scan all db entries of one table and the key are random English words. The table itself only has several hundred entries, but there are also tables with text keys with millions of entries. When I understand the concept right (I don't know), wouldn't that mean, that a huge (common) index would have to be searched and many, many entries skipped, because you use one single key space? Wouldn't that hurt performance very much for that specific operation?