Ifkarsyah
  • Home
  • Resume
  • Portofolio
  • Choosing Tool
  • Book resume
  • Tutorial
    • Apache Flink
    • Apache Kafka
    • PostgreSQL
  • Blog
  • Portofolio
    • Clickstreamer: Clickstream Analytic powered by Apache Flink
    • Gardevoir: Fraud detection and prevention engine powered by Apache Flink
    • Pasin
    • Kanjigen
    • Forfer
  • Blog
    • The Founding Data Engineer’s Playbook: How to Build a Lean, Effective Data Stack
    • Clickstreamer: Clickstream Analytic powered by Apache Flink
    • Gardevoir: Fraud detectio and prevention engine powered by Apache Flink
    • 🎉 Easily create your own simple yet highly customizable blog
    • 🧠 Sharpen your thinking with a second brain
    • 📈 Communicate your results effectively with the best data visualizations
    • 👩🏼‍🏫 Teach academic courses
    • ✅ Manage your projects
  • Book Review
    • Building Machine Learning Pipelines
    • Cost-Effective Data Pipelines
    • Data Intensive Application
    • Data Pipelines Pocket Reference
    • Database Internal
    • Database Internal
    • Deciphering Data Architectures
    • Fundamental of Data Engineering
    • Kubeflow for Machine Learning
    • Streaming Systems
    • Streaming Systems
  • Projects
  • Flink
    • 1. Flink Fundamental
      • Chapter 1
      • Chapter 2
    • 2. Flink for Developer
      • Chapter 1
      • Chapter 2
    • 3. Flink for SRE
      • Chapter 1
      • Chapter 2
    • 4. Flink Internal
      • Chapter 1
      • Chapter 2
  • Resume
  • Agnostic-Engineers
    • Different Type of Query Access Pattern
    • Dual-Write Problem and Outbox Transactional Pattern
    • Same Data in Different Format
    • SQL Tips
  • Apache Kafka
    • 1. Kafka Fundamental
      • 1.1. Introduction to Kafka
      • 1.2. Kafka History
      • 1.3. Kafka Quickstart
      • 1.4. Kafka Topic and Partition
      • 1.5. Kafka Producer and Consumer
      • 1.6. Kafka Producer and Consumer
      • 1.8. Kafka Broker, Cluster, Zookepeer/Raft
    • 2. Kafka for Developer
      • 2. Kafka for e-Commerce
      • 2. Kafka for Ride Hailing
      • Kafka for Fraud Detection
      • Kafka for Realtime Dashboard
      • kafka for realtime notification
    • 3. Kafka for Operator
      • 3.1. Deploying Kafka
      • 3.2. Monitoring Kafka
      • 3.2. Securing Kafka
      • 3.4. Upgrading Kafka
      • Democratizing Kafka in Organizations
  • Choosing-Tools
    • Business Intelligence: Superset vs. Metabase vs. Redash
    • Compute Engine: Spark vs. Flink
    • Data Format: Avro vs. Protobuf vs. Parquet
    • Database Comparison: PostgreSQL vs. MySQL
    • Streaming SQL Engine Comparison
    • Table Format: Hudi vs. Iceberg vs. Delta Lake
  • PostgreSQL
    • 1. Postgres Fundamental
    • 2. PostgreSQL for Developers
      • Ways to Export Data from PosgreSQL to External Sources
      • Ways to Import Data to PostgreSQL
    • 3. Postgres for Operator
    • 4. PostgreSQL Internal
      • How PostgreSQL maps your tables into physical files
      • What is Write-ahead Log? How it Works?
  • Thinking-Frameworks
    • My Framework for Reading (Technical) Books
    • My Framework when Choosing a new Tool

SQL Tips

· 1 min read

https://www.tinybird.co/blog-posts/5-rules-for-writing-faster-sql-queries

Ferdian Ifkarsyah
Authors
Ferdian Ifkarsyah
Data Infrastructure Engineer
← Same Data in Different Format Jan 1, 0001

© 2025 Me. This work is licensed under CC BY NC ND 4.0

Published with Hugo Blox Builder — the free, open source website builder that empowers creators.