This may apply to other engines but I’m primarily focused on myisam. When using optimize table or myisamchk --sort-index, the manual states “Sort index blocks. This speeds up ‘read-next’ in applications.” During this process, does mysql physically sort the index pages on disk to improve sequential io?
Ex: a range lookup on a single column index… it would be great if this was sequential and only required one seek.
Thanks in advance.