select * from sales_history versus Select s.order_ID, s.product_ID, s.price, s.product_name from sales_order s
The simplest rule is to select only the data you need… 292 more words
This is the kind of query that kills some servers – ranking.
It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to think that throwing more hardware will solve all world’s problems… unfortunately it does not work that way. 115 more words