MySQL Loose Scan Optimization: A Comparative Performance Evaluation Against PostgreSQL and MSSQLby@olontsev
3,706 reads

MySQL Loose Scan Optimization: A Comparative Performance Evaluation Against PostgreSQL and MSSQL

tldt arrow
EN
Read on Terminal Reader
Read this story w/o Javascript

Too Long; Didn't Read

An extensive research, showing how Loose Scan optimisation helps MySQL outperforms PostgreSQL and MS SQL Server on GROUP BY queries for columns with low cardinality. And some advice, what could be done in other database engines to mitigate performance issues.
featured image - MySQL Loose Scan Optimization: A Comparative Performance Evaluation Against PostgreSQL and MSSQL
Sergey Olontsev HackerNoon profile picture

@olontsev

Sergey Olontsev

A seasoned software engineer with extensive experience in building complex distributed data-intensive backend services.


Receive Stories from @olontsev


Credibility

react to story with heart
Sergey Olontsev HackerNoon profile picture
by Sergey Olontsev @olontsev.A seasoned software engineer with extensive experience in building complex distributed data-intensive backend services.
Read my stories

RELATED STORIES

L O A D I N G
. . . comments & more!