Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-optimization

MySQL SELECT MAX vs ORDER BY LIMIT 1 on WHERE clause

mysql query-optimization

Why does removing the BINARY function call from my SQL query change the query plan so dramatically?

Why does 'Index Seek' read 20 million rows for `select max(uk) from T where uk <= @x`?

rails force execution of SQL query in where clause

Using datetime index in where clause MySQL

Slow update on update query Postgresql

MySQL Subquery making query super slow

Why does SQL ignore an index hint and opt for a different index?

Entity Framework Core Query Generation

Optimise MySql query using temporary and filesort

mysql query-optimization

How to optimize SQL query with calculating distance by longitude and latitude?

set difference in SQL query

Massive UPDATE vs. MERGE performance on Oracle

Properly Index an UNPIVOT SQL query

Why does this query take over 5 seconds to run?

DECLARE vs. Direct DateTime Conversion Performance Comparison

Debugging PostgreSQL triggers performance

PostgreSQL - Query Optimization