DEV Community

Tomas@PawSQL profile picture

Tomas@PawSQL

I am the founder of PawSQL, a startup revolutionizing SQL optimization. I share database tuning insights and PawSQL's tech, empowering data pros with effective strategies.

Work

Chief Architect@PawSQL

🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques

🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques

2
Comments
4 min read

Want to connect with Tomas@PawSQL?

Create an account to connect with Tomas@PawSQL. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
50x Faster Window Functions? PawSQL's Index Magic Revealed

50x Faster Window Functions? PawSQL's Index Magic Revealed

Comments
3 min read
9 Reasons to Avoid Using SELECT * and 2 Exceptional Cases

9 Reasons to Avoid Using SELECT * and 2 Exceptional Cases

1
Comments
4 min read
Slash Slow Queries by Rewriting OR to UNION

Slash Slow Queries by Rewriting OR to UNION

Comments 1
3 min read
Order by random Optimization

Order by random Optimization

Comments
5 min read
Optimize your SQL by Clicks 00:34

Optimize your SQL by Clicks

Comments
1 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

74
Comments 1
3 min read
IN Subquery Optimization

IN Subquery Optimization

Comments
5 min read
Four Pitfalls of SQL Processing with Null Values

Four Pitfalls of SQL Processing with Null Values

Comments
7 min read
Outer Join Optimization

Outer Join Optimization

4
Comments
5 min read
loading...