Problem: One platform has a login verification, and the login speed is very slow. It took a long time to verify successfully.

After looking at it, the data is less than 1W, so it shouldn't be so slow. After reading it for a while, it is estimated that the execution efficiency during data Select query is too slow.

I wanted to build an index to handle this matter, so I just tried to add a top 1 to select, and the speed increased several times. The problem was solved in this way.

It seems that failure to pay attention to details is a big problem, and I have not paid special attention to the query efficiency of small applications.