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.