As shown in the SQL WHERE conditions are indexed but not used

CodePudding user response:

Filter fields are useless to the index

CodePudding user response:

reference 1st floor sxq129601 response:

filter fields are useless to the index

But the field department, basic are all the same, dictionary department has more than 100, most also must be indexed

CodePudding user response:

You may have a look the execution plan suggest you use index and you originally set up what is the difference between
Under the proposal, by the way you can think of to join in

CodePudding user response:

See you basking fine lines in the execution plan, was too little data