Indexes in MySQL
Indexes in MySQL (Mysql indexes) are a great tool for optimizing SQL queries. To understand how they work, let’s look at working with data without them. Reading data from disk Files are stored in hard drive…
Tag: OLTP
TPC-DS Benchmark On Clickhouse Part 1
ClickHouse ClickHouse is an open source, columnar-oriented database that’s been developed primarily by engineers at Yandex. Yandex is one of Europe’s largest Internet-focused businesses. There search engine alone was receiving 150 million searches a day in 2012. ClickHouse…
Columnar database vs Row based database
Columnar database vs Row based database Columnar database is built for Data Analytics(Small/Big/Bigger) data – OLAP Online Analytical Processing Let us see how analytical queries get benefited by storing data in column oriented database against…