select. . . IN (23,323) Will the index be used?

windancer_ · Post time: 2020-3-11 19:30:01

As the title

dream88 · Post time: 2020-6-4 18:15:01

The conditional column will be used if it has an index

wgfxman · Post time: 2020-6-4 20:15:01

Will do.
Can be seen through the SQL execution plan

cv4bf5d65fd · Post time: 2020-6-4 22:30:01

Multiple records can be indexed by conditional column

我是杀人狂 · Post time: 2020-6-4 23:45:01

See if there is an index

mingbie213 · Post time: 2020-9-1 10:45:01

No, no matter whether the condition column is indexed or not, it will not be used, unless there is only one value in the parentheses after IN. Just look at the execution plan.

		Remember me	Forgot password?
Password			Register