MySQL.

My heavy query crashed our MySQL server.

If I add `LIMIT 10` will it make my query more lightweight? (both for indexed and unindexed queries).

Which way LIMIT are processed: before the rest of the work or after?

I feel that LIMIT makes indexed queries more lightweight, but does not do for unindexed queries. Right thought?