Search code examples
Why does the postgres planner create an all-vs-all join for some queries and not others?...


postgresqlquery-planner

Read More
Why Planing time and Execution time are so different Postgres?...


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
PostgreSQL 12.4 query planner ignores sub-partition constraint, resulting in table scan...


postgresqlpostgresql-12query-planner

Read More
Sorting a large spatial selection is not using GiST index (Postgres 11.5)...


postgresqlpostgissql-execution-planpostgresql-11query-planner

Read More
BackNext