Sobes.tech
Junior — Senior

Creating an optimal index for a complex SELECT query

livecode

Task condition

Formulate an index that will ensure the best performance for the query below.

Select * FROM employee WHERE sex = 'm' AND salary > 300000 AND age = 20 ORDER BY created_ar

Describe which columns should be included in the index and in what order, considering the filtering conditions and sorting.