DEV Community

Tomas@PawSQL profile picture

Tomas@PawSQL

PawSQL provides automatic and intelligent SQL optimization capability for MySQL and PostgreSQL databases. It helps database developers and administrators optimize their queries by Clicks.

Work

Chief Architect@PawSQL

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

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
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

8
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

2
Comments
5 min read
loading...