News for hackers. Stuff that matters.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by guru4consulting on Friday January 31, 2025 @02:56PM (#42891214)
Apart from the above differences, another important difference is that OLAP is often columnar based, as opposed to the typical OLTP being row-based. So, OLAP queries use different kinds of index. Snowflake has introduced Hybrid tables where the same data is stored and indexed twice, once in OLAP columnar type and the other in OLTP style row index.

There are no comments on this comment yet.