Search code examples
Why - or when - doesn't MySQL use indexes for OR conditions, if it does for AND conditions?...


mysqlsqlindexingquery-optimizationexplain

Read More
MySQL EXPLAIN shows key not being used. Is it doing anything at all?...


mysqldatabaseperformanceindexingexplain

Read More
Speeding up PostgreSQL queries (Check if entry exists in another table)...


sqlrpostgresqldplyrexplain

Read More
How is `rows` param in `explain analyze` (postgresql) estimated in case of a function scan?...


sqlpostgresqlsql-execution-planexplain

Read More
MySQL command Explain ignore LIMIT?...


mysqllimitexplain

Read More
Improve a query from Explain results...


mysqlsqlperformancequery-optimizationexplain

Read More
PostgreSQL: Is it possible to print the query plan of a running query?...


sqlpostgresqlsql-execution-planexplain

Read More
How to trigger Mysql parallel query function to start?...


mysqlparallel-processingexplain

Read More
Postgres SLOWER when a LIMIT is set: how to fix besides adding a dummy `ORDER BY`?...


postgresqlsql-order-bysql-execution-planexplain

Read More
Why 'explain' command yields different results on same SQL statement?...


mysqlsqlquery-optimizationexplain

Read More
Indexing in Couchbase - primary index being used instead of secondary index...


jsoncouchbaseexplainsql++database-indexes

Read More
MySQL Distinct from subQuery...


mysqljoinoptimizationdistinctexplain

Read More
Why does an index scan retrieve two rows when there should only be one?...


postgresqlexplain

Read More
Nested Loop Left Join cost too much time?...


postgresqlperformanceexplain

Read More
What does it mean MATERIALIZED in the select_type column in the result of MySQL Explain closure?...


mysqlexplain

Read More
Indexed VARCHAR's key_len...


mysqlvarcharexplain

Read More
PostgreSQL: How to read parallel explain analyze (rows doesn't match single thread)...


sqlpostgresqlparallel-processingexplain

Read More
Postgresql query runs slow and fast. Explain plan shows high shared read...


postgresqlexplain

Read More
MongoDB - explain.executionStats...


mongodbexplain

Read More
How to interpret the output of MySQL EXPLAIN?...


mysqlquery-optimizationexplain

Read More
Which query should be used? Deducing from MySQL Explain...


mysqlinnodbexplain

Read More
Why does PostgreSQL sorts on a boolean WHERE condition?...


sqlpostgresqlsql-execution-planexplainquery-planner

Read More
Postgres EXPLAIN ANALYZE Total Time Appears to Exceed Sum of Parts...


postgresqlexplaindatabase-optimization

Read More
Mysql Explain shows that query is using index when it shouldnt be according to Mysql doc...


mysqlindexingexplain

Read More
Hive explain plan where to see full table scan?...


hivehiveqlexplain

Read More
How to force mariaDB to use index?...


mysqlindexingmariadbexplain

Read More
Explore Spark Execution Plan, number of Stages, etc...


pythonapache-sparkdirected-acyclic-graphsexplain

Read More
Understanding how a hash join works...


postgresqljoinexplain

Read More
Explain analyze: Total time spent executing a task. Documentation error or my error?...


postgresqlsql-execution-planexplain

Read More
MySQL GROUP BY with Using Temporary unnecessarily?...


mysqlexplain

Read More
BackNext