Index Only Access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server
franckpachot.medium.com
Index Only Access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server
1–2 of 2 posts
Re: Index Only Access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server
#2In 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.