Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-optimization

Does SQL SERVER supports FIRST_ROWS feature like oracle does?

How can I improve this endless query?

Query last N related rows per row

Why is this query doing a full table scan?

Optimize a SQL query : call a function or do a join?

Is SQL DATEDIFF(year, ..., ...) an Expensive Computation?

Proper way to access latest row for each individual identifier?

Oracle - Understanding the no_index hint

Is it a good practice to write subqueries in MySQL?

MySQL: Can I do a left join and pull only one row from the join table?

mysql query-optimization

Optimize LEFT JOIN on table with 30 000+ rows

MySQL Query: Long time spent in 'init' state

mysql query-optimization

Optimizing MySQL query to avoid scanning a lot of rows

mysql query-optimization

How to optimize this simple JOIN+ORDER BY query?

Optimal row size to fetch at a time from a big table