Aún no tenemos significados para "index lookup".
1An index lookup is used to satisfy the result of a subquery.
2Apply the conditions to the index lookup operation to eliminate nonmatching rows.
3This is an index lookup that MySQL knows will return at most a single value.
4Secondary index accesses require two index lookups instead of one.
5Why would a secondary index require two index lookups?
6Essentially, any query that's not a single-table indexed lookup requires inter-node communication and therefore is slow.