Not equal join cause aggregation index failure?-CodePudding

Home > database > Not equal join cause aggregation index failure?

Not equal join cause aggregation index failure?

Time：10-20

(the age, the password) is a big table composite index

Composite index key_len=41, the following SQL ken_len=2, only the age to use the index

Why age> 48 would lead to combined index of failure? It can't put more than 48, again according to the age=49 and password=', the age 50 and password==' '... So according to the index?

Page link：https//www.codepudding.com/database/69136.html

Prev:Or connect to multiple fields, show the explain using an index, the actual time consuming and no ind

Next:MSSQL database to establish links with the sybase server error [100]

Tags：

The base class

Links：
CodePudding