Tomas articles - 15 total
Free & Self-hosted EverSQL
PawSQL Community Edition: A Free & Self-Hosted...
PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers
1.1 Overview of PawSQL PawSQL is an enterprise-grade database performance-tuning platform that covers...
PawSQL for Jetbrains - Optimize your SQL Queries within Jetbrains IDEs
💡 Introduction PawSQL for Jetbrains (PawSQL Client) is a powerful Jetbrains plugin that...
🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques
1️⃣ Introduction This article dives into the process of optimizing the TPC-H benchmark Q2...
50x Faster Window Functions? PawSQL's Index Magic Revealed
Introduction In the realm of database performance optimization, SQL queries involving...
9 Reasons to Avoid Using SELECT * and 2 Exceptional Cases
We often see articles warning that using SELECT * is a bad habit and columns should be explicitly...
Slash Slow Queries by Rewriting OR to UNION
Problem Definition If two query conditions are connected by OR, the database optimizer may...
Want to Boost Database SQL Performance? This JetBrains Plugin Has You Covered!
Overview PawSQL Advisor is an automated, intelligent SQL optimization tool developed by...
Order by random Optimization
Copyright © 2023 PawSQL Problem Functionrand(MySQL) or random(PostgreSQL) returns a...
Optimize your SQL by Clicks
Three clicks to optimize your SQL queries by PawSQL.
Join Elimination - Advanced SQL tuning
Channel of advanced SQL tuning Definition Join Elimination is a rewriting optimization...
IN Subquery Optimization
Channel of advanced SQL tuning Problem Definition An IN subquery is a type of subquery...
Four Pitfalls of SQL Processing with Null Values
Channel of advanced SQL tuning Originally published at...
Outer Join Optimization
Channel of advanced SQL tuning Types of Joins The types of SQL joins mainly include...
Principles of Database Index Design
Channel of advanced SQL tuning Overview Indexes are one of the most important tools for...