Skip to content

Philip McClarence

  • PostgreSQL
    • Aurora
    • Errors
    • How To – Postgres
  • MongoDB
  • MySQL
  • Cassandra
  • Hadoop
  • Oracle
    • Oracle Basics
    • Oracle News
    • Errors
    • Oracle Tasks
    • Oracle RAC
    • Oracle Tuning

Tuning

SQL Plan Baselines.

03/02/201403/02/2014 by Philip

SQL plan baselines are a new feature introduced in Version 11g. SQL execution plans determine how a query is executed and the path that is taken to retrieve the data. Plans can be evolved or improved over executions and should only change when a better plan can be found. When a query is hard parsed, …

Read more

Categories Oracle Basics, Oracle Tuning Tags execution plan, Tuning Leave a comment

Categories

  • Cloud (10)
    • AWS (10)
      • AWS Glue (4)
      • Lake Formation (2)
  • Data Warehousing (6)
  • Databases (911)
    • Big Data (3)
      • Cassandra (2)
      • Hadoop (1)
    • MongoDB (5)
    • MySQL (519)
      • Errors (515)
    • Oracle (208)
      • Errors (2)
      • Oracle Basics (35)
      • Oracle RAC (12)
      • Oracle Tasks (4)
      • Oracle Tuning (4)
    • PostgreSQL (339)
      • Aurora (12)
      • Errors (256)
      • How To – Postgres (45)
      • Postgres Performance Tuning (8)
    • RedShift (5)
  • Featured (11)
  • Self Improvement (3)
  • Tutorial (7)
  • Uncategorized (12)
  • Video (10)

Recent Posts

  • pg_cron Guide: Scheduled Jobs, Monitoring & Gotchas
  • Aurora PostgreSQL Storage Architecture Explained
  • Postgres Time-Series Partition Maintenance, Done Right
  • pgvector Index Tuning: HNSW vs IVFFlat, Explained
  • Postgres Is Down: A 5-Minute Triage Tree
  • pg_cancel_backend vs pg_terminate_backend: Full Runbook
  • Postgres TOAST: A Practical Storage Checklist
  • Postgres Row-Level Security: A Multi-Tenant Playbook
  • Postgres Full-Text Search vs Elasticsearch: A Real Comparison
  • Fix “No pg_hba.conf Entry for Host” in Postgres
  • Postgres Wait Events: A Practical Triage Guide
  • Postgres Replication Lag Is Four Numbers, Not One
  • UUID vs BigInt Primary Keys in Postgres: Index Bloat Explained
  • How to Increase max_connections in Postgres Safely
  • PostgreSQL Transaction ID Wraparound: Cause and Fix
  • Postgres Free Space Map: Why Deletes Don’t Shrink Tables
  • Partition Pruning Isn’t Magic — Here’s When It Actually Works
  • Auto_explain PostgreSQL: Capture Slow Query Plans in Production
  • Postgres jsonb_array_elements: Turn JSON arrays into queryable rows inside SQL
  • Physical and logical replication solve different problems at different layers of
© 2026 Philip McClarence • Built with GeneratePress