Performance Basics

Performance Basics – overview

Allgemeiner Text zu Indexen, Partitionierung, Caching und generellen Performance-Themen.

Performance Basics in PostgreSQL

Platzhalter-Intro-Text für PostgreSQL zum Thema Performance.

POSTGRES – code

-- snippets/performance-basics/code-postgres.sql
-- Platzhalter-Code für Joins in PostgreSQL
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Performance in PostgreSQL. Platzhalter-Text.

Performance Basics in Snowflake

Platzhalter-Intro-Text für Snowflake zum Thema Performance.

SNOWFLAKE – code

-- snippets/performance-basics/code-snowflake.sql
-- Platzhalter-Code für Joins in Snowflake
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Performance in Snowflake. Platzhalter-Text.

Performance Basics in Redshift

Platzhalter-Intro-Text für Redshift zum Thema Performance.

REDSHIFT – code

-- snippets/performance-basics/code-redshift.sql
-- Platzhalter-Code für Joins in Redshift
SELECT
    c.customer_id,
    c.customer_name,
    o.order_id,
    o.order_date
FROM customers c
JOIN orders o
  ON o.customer_id = c.customer_id;

Kurzfazit zu Performance in Redshift. Platzhalter-Text.