Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-optimization

SUM query on millions of records is slow even with indexes, how can I optimize?

sql many-to-many query indexes optimization

query with 'NOT IN' condition is too slow

there is a way to optimize this mysql query?

Better SQL Replace

Hive query performance for high cardinality field

Why is MySQL not using index for simple "SELECT * FROM Table WHERE field='value'" query?

Why aren't indexes used in the first case but work in the other?

Mysql Order BY Speed

MySQL query using GROUP BY is extremely slow

MySql Delete Taking A Long Time

How to optimize retrieval of most occurring values (hundreds of millions of rows)

How to optimize a DQL query in Symfony2?

optimize the mysql query

Postgres Select ILIKE %text% is Slow On Large String Rows

Postgresql View aggregating data

Postgresql slow query with limit and order by [duplicate]

Optimizing SQL query that have multiple joins