Live data from Hacker News

Index Only Access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server

franckpachot.medium.com

1–2 of 2 posts

Re: Index Only Access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server

#2
In summary

Oracle and MySQL with InnoDB engine are the ones who can really do Index Only, aka Covering Index, in a high OLTP (where readers do not block writers). SQL Server can also do it, but with reads blocking writes (except with snapshot isolation). PostgreSQL can also do it, with non-blocking reads, but not efficiently when the tables have concurrent modifications.