For a simple query like this, then yes, it will be optimised. But once your queries get more complicated, the optimiser might not be able to make that deductio

For a simple query like this, then yes, it will be optimised. But once your queries get more complicated, the optimiser might not be able to make that deduction on its own.