#sql-optimization

[ follow ]

API with NestJS #181. Prepared statements in PostgreSQL with Drizzle ORM

Using prepared statements improves query execution efficiency in PostgreSQL.
Prepared statements are session-specific, meaning they don't persist beyond the current session.

Optimizing JOIN Operations in Google BigQuery: Strategies to Overcome Performance Challenges | HackerNoon

Optimize JOIN operations in BigQuery by implementing partitioning and pre-filtering to manage large datasets effectively.
[ Load more ]