In the real world such indexing methods aren’t practical, once you have to do a full text search for example or sort by some attribute the index becomes useless

In the real world such indexing methods aren’t practical, once you have to do a full text search for example or sort by some attribute the index becomes useless. It’s rare to only want results presented in a certain order IMO.