Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
A guide to using the new 'Compare ShowPlan' feature in SQL Server Management Studio 2017 to analyze and contrast SQL execution plans.
Explains why SQL Server's dm_exec_query_plan returns NULL for stored procedures with conditional logic and temp tables, and how to diagnose it.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
Explains the importance of clearing SQL Server's data and execution plan caches for fair query performance comparisons during tuning.
