Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-execution-plan

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

Why actual time in EXPLAIN result is different with every execution in PostgreSQL?

User-Defined Functions - Are they poor coding practice?

How to find out the temp space that will be required by a sql query on a database?

Explain Vs Desc anomalies in mysql