What’s the difference between “type=index, key=PRIMARY” and “type=ALL” in MySQL explain statement?
As I understand, in MySQL’s execution plan, when type=ALL, MySQL will scan the PRIMARY index; when type=index, MySQL will scan the index which is in “key” column, what if key=PRIMARY? What’s the difference between them?