Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-optimization

How to do fast counting on large tables?

Whats faster in Oracle? Small table with tree structure vs. Huge flat table

What should be the order of filters in query to optimize queries to use Indexing

Is it possible there is a faster way to perform this SELECT query?

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