Sql, Spl, Database.
TOP 10 * FROM Orders ORDER BY Amount DESC As we can see that although this code is not complex, it has the keyword ORDER BY, which means doing a big sorting on all data first, and then taking the TOP 10. The big sorting is very slow, involving multiple times of swaps between memory and external