Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-execution-plan

"Estimated Number of Executions" is inflated

How to decrease total timing processing of Spark SQL Execution plan

HashAggregate in SparkSQL Query Plan

What does "Using sort_union" mean?

mysql sql-execution-plan

Why NonClustered index scan faster than Clustered Index scan?

How does postgres decide whether to use index scan or seq scan?

How to understand SQLite `EXPLAIN QUERY PLAN` result?

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

How to fix PostgreSQL generic plan estimate for any($1) array parameter?

LIMIT with ORDER BY makes query slow

Efficient PostgreSQL query on timestamp using index or bitmap index scan?

Postgresql huge performance difference when using IN vs NOT IN

Oracle JOIN operation performance changes when swapping SELECT statements

Postgresql ignoring index on timestamp column even if query is faster using index

How do I know what's behind the `auto_key0` index in MySQL?

Strange problem with SQL Server procedure execution plan

Does Oracle chose a default execution plan when parsing a prepared statement?

What is the "filtered" column in MySQL EXPLAIN telling me, and how can I make use of it?

Explain Vs Desc anomalies in mysql