Or connect to multiple fields, show the explain using an index, the actual time consuming and no ind
(the age, the password) is a big table aggregation index, id primary key
The big table a full table scan is probably more than 4 seconds
Why the or connection statement USES the full table scan?
SQL execution plan shows that using the index!
Why can so fast into the union