use the following search parameters to narrow your results:
e.g. subreddit:pics site:imgur.com dog
subreddit:pics site:imgur.com dog
advanced search: by author, sub...
~4 users here now
Links:
Index-only scans in Postgres
submitted 5 years ago by akerro from medium.com
view the rest of the comments →
[–][deleted] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 0 fun3 insightful - 1 fun - 5 years ago (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
view the rest of the comments →
[–][deleted] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 0 fun3 insightful - 1 fun - (0 children)