Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-optimization

INSERT INTO SELECT is very slow, but INSERT or SELECT are fast when running separetely

MySql Query for Authors and Books written Count

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