• Generally speaking (as this is a general question), probably Option 1 as it lets Oracle pick the best way of applying predicates. Under limited circumstances, option 2 will limit the way in which it applies predicates.

    Ask a general question get a general answer.