MySQL Loose Scan Optimization: A Comparative Performance Evaluation Against PostgreSQL and MSSQL
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.
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.