Defining OLAP or OLTP on table level in Oracle/postgres/SQLserver
Oracle includes an in-memory columnar store that lets you combine OLAP-style queries on top of a plain tabular data mode without requiring any transformation
See https://docs.oracle.com/en/database/oracle/oracle-database/12.2/inmem/intro-to-in-memory-column-store.html#GUID-BFA53515-7643-41E5-A296-654AB4A9F9E7