Search code examples
Why Planing time and Execution time are so different Postgres?...

postgresqlquery-planner

Read More
Resolving Poor Execution Plan in SQL Server with CLR Scalar Function...

sql-servert-sqlquery-optimizationsqlclrquery-planner

Read More
Idiomatic way to push WHERE condition through OUTER JOIN in Postgres?...

sqlpostgresqljoinquery-optimizationquery-planner

Read More
Why does the postgres planner create an all-vs-all join for some queries and not others?...

postgresqlquery-planner

Read More
Vastly different query performance on GIN indexed table using different search words...

postgresqlquery-optimizationdatabase-performancequery-planner

Read More
Why is Postgres query planner affected by LIMIT?...

sqlpostgresqlpostgresql-9.3query-planner

Read More
postgres LIKE % operator vs similarity - pg_trgm.similarity_threshold . different query plans...

postgresqlindexingsimilarityquery-planner

Read More
Why does PostgreSQL not use the index in this scenario?...

postgresqlperformancepostgisquery-planner

Read More
Where condition dramatically reduces performance unexpectedly...

sqlsql-serverquery-optimizationquery-planner

Read More
Getting Index Scan instead Index Seeking if IN clause larger in Azure Sql...

sql-serverindexingnon-clustered-indexazure-data-studioquery-planner

Read More
Correct planner estimate of 1:1 join without FK or left join...

postgresqlquery-optimizationsql-execution-planquery-planner

Read More
Does a covering index have an effect on JOIN + BETWEEN operations...

sqlsqlitequery-plannercovering-index

Read More
Replace OUTER APPLY...

sqlsql-serverquery-plannerouter-apply

Read More
Query slows down 5 fold after copying DB (on the same computer!)...

postgresqlconfigurationpostgresql-performancequery-planner

Read More
PostgreSQL: Dirtied blocks when using many OR conditions in query...

postgresqlpostgresql-13query-planner

Read More
Match any value from a long list with a postgres GIN index...

postgresqlquery-planner

Read More
Why does removing the BINARY function call from my SQL query change the query plan so dramatically?...

mysqlsqlquery-optimizationcollationquery-planner

Read More
Relpages and reltuples under MVCC...

databasepostgresqlquery-plannermvcc

Read More
Gap in the execution-time parts in the query plan...

postgresqlquery-optimizationquery-planner

Read More
Why is Postgres performance greatly reduced upgrading from 9.2.24 to 10.17?...

postgresqlquery-planner

Read More
Why index scan instead of seek while using comparison operator...

sql-servert-sqlquery-optimizationquery-planner

Read More
Different execution plan for local PostgreSQL client for same query...

postgresqlquery-planner

Read More
Strange Query Plan for SQL Query - Clustered Index Seek...

sqlsql-serverfull-text-searchquery-planner

Read More
Why plainning time is doubled when I call IMMUTABLE function with exatly same arguments second time?...

postgresqlquery-optimizationquery-planner

Read More
Why optimization is not applied/different index is used?...

postgresqlpostgresql-performancequery-planner

Read More
Does SQL Server consider which index is already in memory (cached) in query plan?...

sql-serverindexingquery-planner

Read More
PostgreSQL n_distinct statistics setting...

postgresqlquery-planner

Read More
PostgreSQL upgrade to 12+ changes hash join to slow nested loop...

postgresqlcommon-table-expressionquery-planner

Read More
How many disk pages are read by a query in Postgres?...

sqlpostgresqloptimizationquery-planner

Read More
Query plan caching with pl/pgsql...

postgresqlcachingdatabase-designplpgsqlquery-planner

Read More
BackNext