Skip to content

The index that does not help

Employee has an index on (dept_id, salary), in that order.

Which of these queries can not use it efficiently?