StackOverflow Questions for Tag: query-planner

TheMemeMachine

Reputation: 423

Does the query execution planner in mysql v8 recognize that x=1 and x in(1) are the same

sqlmysqlperformancequery-planner

Score: 0

Answers: 0

Thor Samsberg

Reputation: 2279

Why Planing time and Execution time are so different Postgres?

postgresqlquery-planner

Score: 26

Answers: 2

Nelson O

Reputation: 295

Resolving Poor Execution Plan in SQL Server with CLR Scalar Function

sql-servert-sqlquery-optimizationsqlclrquery-planner

Score: 2

Answers: 1

paperskilltrees

Reputation: 382

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

sqlpostgresqljoinquery-optimizationquery-planner

Score: 2

Answers: 1

Lawrence

Reputation: 797

SQLite query using TEMP B-TREE FOR ORDER BY instead of index

sqlitesortingindexingquery-planner

Score: 4

Answers: 1

afarrell

Reputation: 35

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

postgresqlquery-planner

Score: 2

Answers: 1

reflow

Reputation: 11

MongoDB seems to use different index than it chooses when using explain

mongodbquery-plannermongo-index

Score: 0

Answers: 1

Han Qi

Reputation: 503

How do 2 query plans on the same table have large row estimation differences

postgresqlquery-planner

Score: 0

Answers: 0

Maxim Mandrik

Reputation: 447

PostgreSQL CTE by id string is very cheap, but by id from query is very expensive

postgresqlcommon-table-expressionpostgresql-13query-planner

Score: 0

Answers: 3

Vijay Kansal

Reputation: 839

Mysql index hints in Hibernate query

mysqlhibernateindexingquery-planner

Score: 4

Answers: 4

Jorge Domínguez Arnáez

Reputation: 1

How can I tell the SQL planner that a WHERE condition in the main query should be executed in the subqueries?

sqlpostgresqlquery-optimizationpostgresql-performancequery-planner

Score: 0

Answers: 1

Mcscrag

Reputation: 65

Postgres Query Planner expects 1 row for a join doing a Nested Loop Join

postgresqlperformancequery-planner

Score: 0

Answers: 0

Stefan FPF

Reputation: 33

Vastly different query performance on GIN indexed table using different search words

postgresqlquery-optimizationdatabase-performancequery-planner

Score: 3

Answers: 1

Andrew

Reputation: 1074

Postgres order of execution in query that computes a function and locks rows

sqlpostgresqlquery-planner

Score: 1

Answers: 0

Julius Žaromskis

Reputation: 2255

Why is Postgres query planner affected by LIMIT?

sqlpostgresqlpostgresql-9.3query-planner

Score: 4

Answers: 1

J. Dieckmann

Reputation: 43

bad performance of postgres query if on-clause of inner-join is positioned after following left-joins

left-joinpostgresql-11query-plannerhibernate-6.xon-clause

Score: 2

Answers: 0

alyshan

Reputation: 176

How can I update the statistics of a table in cockroachdb

sqldatabasecockroachdbquery-planner

Score: 0

Answers: 1

tim

Reputation: 1

Postgresql chooses a slower plan for a query involving gin + btree index, after table update

sqldatabasepostgresqloptimizationquery-planner

Score: 0

Answers: 2

Viktor Egorov

Reputation: 71

PostgreSQL Index Not Utilized for JSONB Field Filtering on Non-Equality: What Am I Missing?

postgresqlsql-execution-planpostgresql-12query-plannerpartial-index

Score: 1

Answers: 1

Adam

Reputation: 2440

Why does varchar(max) column in concat function cause query plan to blow up

sql-servert-sqlquery-plannerhashbytes

Score: 2

Answers: 0

PreviousPage 1Next