How to optimize queries?
Answer
•EXPLAIN.
•Indexes.
•Avoid SELECT *.
•LIMIT.
•No functions on indexes.
Was this answer helpful?
More questions in this topic
Related questions from other topics
- How to optimize queries?Programming · PHP
- How to avoid prop drilling?Programming · React
- How to type callback functions?Programming · TypeScript
- What are overloads of functions?Programming · TypeScript
- How to type validator functions?Programming · TypeScript
- How to avoid memory leaks in React?Programming · React