sql-execution-plan tutorials

SQL Server - why is scanning done twice for the same table?

Oct 11, 2022

sql sql-server sql-execution-plan

Different execution plan when executing statement directly and from stored procedure

Oct 22, 2022

sql sql-server tsql stored-procedures sql-execution-plan

Restricted Text when Reviewing Execution Plan in SQL Server Management Studio

Jan 16, 2020

sql sql-server ssms sql-execution-plan

Is there a way to make Oracle recalculate a query plan for each query invocation?

Oct 28, 2022

oracle sql-execution-plan

Why would MySQL use index intersection instead of combined index?

Nov 19, 2022

mysql query-optimization sql-execution-plan database-indexes

Are execution plan for functions cached in SQL server?

Nov 15, 2022

sql-server function tsql sql-execution-plan sql-function

What's the difference between these T-SQL queries using OR?

Oct 20, 2022

sql-server sql-server-2008 database-performance sql-execution-plan

PostgreSQL: The lower the LIMIT, the slower the query

Oct 25, 2022

sql postgresql query-optimization sql-execution-plan

Execution plan not as expected

Oct 31, 2018

sql oracle performance sql-execution-plan

Why does vacuum analyze change query plan while analyze does not?

Oct 16, 2022

postgresql sql-execution-plan postgresql-9.4 vacuum autovacuum

Same query, different execution plans

Jan 21, 2018

sql-server performance execution sql-execution-plan

What is the significance of the order of statements in mysql explain output?

Dec 20, 2019

mysql sql-execution-plan

Not Exists vs Not In: efficiency

Mar 21, 2019

sql sql-server tsql exists sql-execution-plan

How can a table scan return more rows than are in the table?

Dec 16, 2021

sql-server sql-execution-plan

How do I explain a query with parameters in MySQL

Sep 23, 2022

mysql sql-execution-plan

Postgres uses wrong index

Apr 24, 2022

postgresql indexing postgresql-performance sql-execution-plan

What are SQL Execution Plans and how can they help me?

Apr 13, 2022

sql-server tsql sql-execution-plan

SQL function very slow compared to query without function wrapper

Apr 14, 2021

postgresql function postgresql-performance sql-execution-plan

Execution plan over query with temp tables

Mar 21, 2022

sql-server sql-server-2008-r2 sql-execution-plan

Postgresql - How to speed up for updating huge table(100 million rows)?

Oct 22, 2022

performance postgresql sql-update sql-execution-plan

New posts in sql-execution-plan