Index-only scans in Postgres

submitted by akerro from medium.com

sorted by:
top
newinsightfulfun
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 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