Sometimes, part of the predicate can be pushed down to the IXSCAN stage filter and minimise or even avoid fetching. 

Predicate: AND [a=1, b=1]

Sort: c_1

Index: (c_1_a_1)

Resulting query

FETCH
    filter: AND [a=1, b=1]
    IXSCAN:
        pattern: (c_1_a_1)

Optimal query:

FETCH
    filter: b=1
    IXSCAN:
        filter: a=1
        pattern: (c_1_a_1)