S
S
sasha2014-05-10 14:51:13
MySQL
sasha, 2014-05-10 14:51:13

Is it possible to optimize a SQL query?

There is a SQL query to the MySQL database, which runs for one and a half seconds. EXPLAIN of this query produces this
eac81f2e8bfe44da93ce579c7405b7b9.png
and the question is this: is it possible to optimize such a query without touching the structure of the database (well, except for adding additional indexes and other improvers)?
I'll listen to any suggestions ;)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Vershinin, 2014-05-10
@madmages

Most likely, ORDER BY is taking so long.
ORDER BY optimization

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question