Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-execution-plan

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?

Extracting data from SQL Server's XML execution plan

How accurate is Oracle's EXPLAIN PLAN?

Different Execution Plan for the same Stored Procedure

MySQL slow query with join even though EXPLAIN shows good plan

How to optimize mysql query based on explain. (Type: ALL

Understanding explain plan through xmltype

mysql multi column index not working (as expected)?

Oracle equivalent of Postgres EXPLAIN ANALYZE

SQL Error: ORA-01039: insufficient privileges on underlying objects of the view

Explain Vs Desc anomalies in mysql