Shiv Iyershiviyer.hashnode.dev·Aug 3, 2024Leveraging Anti-Joins in SQL for Advanced Database Engineering: Techniques and Best PracticesOptimizing Natural Joins in MariaDB Using the Sort-Merge Algorithm The Sort-Merge join algorithm is a powerful technique for optimizing join operations, especially when dealing with large datasets. This algorithm works by first sorting the input tabl...46 readsMariaDB
Shiv Iyerpostgresqlblog.hashnode.dev·Aug 2, 2024Essential Tips for Optimizing PostgreSQL Semi-Joins and Anti-JoinsIntroduction Optimizing database queries is crucial for achieving high performance and scalability, especially when working with large datasets. In PostgreSQL, semi-joins and anti-joins are powerful techniques used to filter results based on the exis...158 readsclosing
