all 1 comments

[–]d3rr 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (0 children)

Cool optimization for the right read queries. Apparently MySQL/Maria have been doing this for some time and call it a 'covering index':

https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_covering_index

https://blog.toadworld.com/2017/04/06/speed-up-your-queries-using-the-covering-index-in-mysql