It is said that senior programmers know 6 SQL optimization skills

Photo by Matthias Götzke on Unsplash

In our work, SQL optimization is often encountered, and everyone is familiar with it, but everyone has their own way of optimizing techniques. In the project, if there is a performance problem in the interface of our production environment, what should we do?

For experienced friends, the first thing that comes to mind is to optimize the sql statement…