Filter by Column MySQL vs Clickhouse

Filter by column was a typical business case requirement for reporting or creating analytical dashboards. Even though there are many OLAP databases available in market . In this blog post i will delve deep in…

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…