Storing data in a columnar format in the database’s memory allows faster data access and improves compression efficiency. In-memory also uses advanced algorithms and optimisations to speed up analytical queries. And the dual-format architecture makes it ideal for mixed workloads.