As the question,
use just learned mysql index is to use B+ tree to achieve, if the id is autoincrement id, in the search data will use binary search, greatly improve the efficiency of the query.
But if the primary key is a string and unique. So if I execute a select statement is equal to scanning the whole table?
So, if we use uuid as the business id, what optimizations are available to optimize query efficiency?