SQL Processing - Relational Database Index Design and the Optimizers - page 45

3.2. Design the best possible indexing for the following query:

SQL 3.8

SELECT LNAME, FNAME, CNO

FROM CUST

WHERE SEX = 'M'

AND
(WEIGHT > 90
OR
HEIGHT > 190)

ORDER BY LNAME, FNAME